Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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