Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
teruru
Contributor III
Contributor III

Calendar / Table association

Hi,I'd like to associate the 3 tables (Table A ,B and C).

TableA  is calendar table I created with script and Table B and C are data loaded by excel file.
The column of table A is only calendar date.
The columns of table B are data number and date.
The columns of table C are data number and location.

How can  I associate these thress tables with date?

Thank you.

5 Replies
Aasir
Creator III
Creator III

I don't see a common column in all three. What you can do is link A and B with the Date column and A link with B & C with the data column. You can do this association just by drag and drop in data manager.
 

teruru
Contributor III
Contributor III
Author

Thank you so much.
I need a common key in each table.

When I associate the date from table A and table B, should I named the same name?

Aasir
Creator III
Creator III

@teruru it's not necessary but if you give them common names it will auto-associate once you run the script.

teruru
Contributor III
Contributor III
Author

Is there any ways to associate the dates?

Aasir
Creator III
Creator III

@teruru same just drag and drop in Data Manager or have common names in both tables