Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have a script where i load many excel files in 1 loop. All the files have the same layout.
For each file i want to know the rownumber for each column.
From this forum i found the solution:
LOAD
RowNo() as A,
Column2,
Column3
FROM [excel_file];
The problem is that this works fine for the first excel file, but it counts further for the next excel.
If i have a template like this in excel:
So in qlikview i want to add the rownumber to the question (2,3,4,5).
But the second excel he counts further (6,7,8,9).
The initial idea was to use the question as identifier, but some question are the same formulated (in other groups). Changing all the templates is not possible (too much work.....)
Anyone a good idea? Summery: need something like rowno(), which starts counting for each excelfile reading...
Have you tried using RecNo() ?
Have you tried using RecNo() ?
ARGH..... yes... that works.!!!.... Spend several hours on this......
Thanks Jqjackso!