Discussion Board for collaboration on QlikView Scripting.
I have the foloowing table (simplified of course):
Now what i want to make is the following table
So basically i want to load each row in the top-table and then use a FOR-loop to create rows in a new table.
I was thinking to loop through the lines, then set two vars with peek (from and to), and then loop from 'from' to 'to' and create the lines in table 2.
Am I thinking in the wrong direction? Cause I can't seem to nest two for statements....
Go to Solution.
Date & '-' & Code as [DAY-CODE-KEY],
LOAD Date(FROM_Date + IterNo() - 1) as Date,
While FROM_Date + IterNo() - 1 <= TO_date;
Load * Inline [
FROM_Date, TO_date, Code, Manager
01-01-2016, 03-01-2016, 100, Hank
01-01-2016, 05-01-2016, 101, Edward
I think you can use the intervalmatch function. Take a look at this script and see if it can help you along the way.
Thanks, this time I chose the iterative solution provided by Sunny.
Thanks for the example of proper use of an interval function.
Thanks, works exactly as needed.