Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everybody,
How can i create link table for 3 or more tables?
I have 3 tables with date field and i need break them in year, month, day and week-day.
Thank you
Hope the below blog of Stephen Redmond with detailed information about creating link tables could help you:
http://www.qliktips.com/2011/05/rules-for-creating-keylink-table-in.html
Hi,
Try scenario:
[Table1]:
LOAD
FA1 AS [FA1-FB1], //Table1 link to Table2 with field [FA1-FB1]
FA2,
FA3
FROM ...
[Table2]:
LOAD
FB1 AS [FA1-FB1],
FB2 AS [FB2-FC1], //Table2 link to Table3 with field [FB2-FC1]
FB3
FROM ...
[Table1]:
LOAD
FC1 AS [FB2-FC1],
FC2,
YEAR(FC2) AS [Years],
MONTH(FC2) AS [Months],
DAY(FC2) AS [Days],
WeekDay(FC2) AS [WeekDays]
FC3
FROM ...
Just an idea and hope it help you.
Regards,
Sokkorn
Hope the below blog of Stephen Redmond with detailed information about creating link tables could help you:
http://www.qliktips.com/2011/05/rules-for-creating-keylink-table-in.html