Many to many

[NourJ]

Dear all

I have two tables contain two similar columns but one of them is for 2018 and the other is for 2019, how I can unify them,

kindly note that I have a date column in both (Day, Month, Quarter and Year), also there is a location column in both but the relation is 'many to many' , and 2019 is a reference from 2018 so I couldn't append them as well !!

many thanks in advance,

Nour

[TeigeGao]

Hi @NourJ ,

It's sorry that I can't understand your requirement very well, could you please share the sample data and expected result to us for analysis?

Best Regards,

Teige