Linking columns

[ShahbazovT]

Hi experts. I need your help.  

I have two tables as below . I want to create new Table3 and linking Date and Product columns in new Table3.  

Please help.

[Ksrinivasan]

hi,

you can use left join like below

TBJ:
load
"Date",
Product
FROM SSS1.xlsx]
(ooxml, embedded labels, table is tablejoin1);
left join
LOAD
Date_01,
Product
FROM [lib:/SSS1.xlsx]
(ooxml, embedded labels, table is [tablejoin1 (2)]);

ksrinivasan

[marcus_sommer]

Why a new table and linking them? If there is no very special reason for it shouldn't be done else just concatenating the tables would be more suitable.

- Marcus

[ShahbazovT]

I want to create "Time table" and link these tables date columns to "calendar table". 

[ShahbazovT]

Thanks. I will try this way🙏

[marcus_sommer]

It's not really clear - a time table which is linked with your other tables and a calendar table ... it sounds quite complicated and does it really have a benefit?

Nothing is more simple as just to concatenate two fact-tables. Therefore I suggest to start with this approach.

- Marcus