Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
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?
@teruru it's not necessary but if you give them common names it will auto-associate once you run the script.
Is there any ways to associate the dates?
@teruru same just drag and drop in Data Manager or have common names in both tables