Discussion board where members can learn more about Qlik Sense Data Connectivity.
Hi - I have the following resident table :
With the following Fields:
Product ID Product Value
I would like to have a loop that will create a new table with one year of dates starting from the system date (today) for each of the product ids.
So for example (new table)
Product Calendar Date
ABC 1002 8/5/2020
ABC 1002 8/6/2020
ABC 1002 8/7/2020
DEF 2025 8/5/2020
DEF 2025 8/6/2020
DEF 2025 8/7/2020
GHI 3020 8/5/2020
GHI 3020 8/6/2020
GHI 3020 8/7/2020
and so on and so on....
any thoughts on how to do this ?
can weekend dates be excluded ?
Thanks - Jerry
hi add this load statement to the script
after the initial build of the table
NoConcatenate Load *
drop table ProductInfoCalendarTable;
View solution in original post
something like this should work
date(today()+iterno()-1) as ProductCalendarDate
this worked perfect - thank you !
How can I remove the weekend days ?
Thank you very much - appreciate it !