Discussion board where members can get started with QlikView.
I have a data table in excel like this:
And my expectation output should be like this:
But the field name in Row 1 (in Picture 1 above) is dynamic, which means can be changed everytime.
I put a script like this:
Date(A,'M/DD/YYYY') as [DATE__1FCPOX8],
Num(B,'0.00') as [VALUE__1FCPOX8],
Date(C,'M/DD/YYYY') as [DATE__1FCPOZ8],
Num(D,'0.00') as [VALUE__1FCPOZ8]
But it didn't covered a dynamic name field.
Do you have any solutions about this case?
Try like this:
(ooxml, explicit labels, table is Sheet1, filters(
Remove(Row, RowCnd(Interval, Pos(Top, 2), Pos(Bottom, 1), Select(1, 0))),
LOAD CalendarMonthNumber as [$(vField1)_ABC],
CalendarMonthName as [$(vField2)_ABC],
Actuals as [$(vField3)_ABC],
[Required Run Rate] as [$(vField4)_ABC]
(ooxml, embedded labels, table is Sheet1);
In table A, simply replace the path with your path and change the format if yours is different.
Then create variable depending on the number of fields you have, you can automate this also by using loop, I just build this in hurry .
Or you can try this solution:
Looks like the solution you describe is almost correct.
For this section:
Could you bring the sample script to automate this by using loop? In case I have a large number of field.