How to match dates correctly

[maxsugak]

Hi,

lets say I have 2 tables with different data, but each of them has it own date information, for example:

- 1st table has fields Year,  Month, Week.

 - 2nd table has fields Year, Week.

And also I have a key field named ProductID.

What is the best way to match this two tables without synthatic key? I would use same date filter for both tables.

Thanks!  

[pradosh_thakur]

Hi @maxsugak 

It will be unfair without knowing the background and ask you do something to remove the synthetic key. If both the year and week corresponds to the same date like start date for example you can omit something but if they are different you may need to separate them and create date out of it. 

As i said there could be different ways to do it depending upon the data, some back ground of it would make our job easier.

Thanks

Pradosh

[maxsugak]

Thanks for your response!

I've made quick example attached.

[maxsugak]

SKU is a key field

[Channa]

concat(year,week)

in both tables and join it will avoid synthatic key

synthatic key is not a problem