topic Linking columns in App Development

Linking columns

ShahbazovT — Fri, 02 Apr 2021 08:47:59 GMT

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.

Re: Linking columns

Ksrinivasan — Thu, 21 Jan 2021 09:17:09 GMT

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

Re: Linking columns

marcus_sommer — Thu, 21 Jan 2021 10:14:58 GMT

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

Re: Linking columns

ShahbazovT — Thu, 21 Jan 2021 14:21:49 GMT

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

Re: Linking columns

ShahbazovT — Thu, 21 Jan 2021 14:22:47 GMT

Thanks. I will try this way🙏

Re: Linking columns

marcus_sommer — Thu, 21 Jan 2021 14:42:27 GMT

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