Add linenumber from several excel files

[intervigilium]

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...

[jwjackso · Accepted solution]

Have you tried using RecNo() ?

[intervigilium]

ARGH..... yes... that works.!!!.... Spend several hours on this......

Thanks Jqjackso!