topic Re: Add a Rowno() on many added tables in QlikView

Add a Rowno() on many added tables

Antoine553 — Sat, 16 Nov 2024 18:04:22 GMT

Hello

I have many xlsx file going from 2005 to 2020. I'm starting by loading the 2020.xlsx file and add the others by making a "ADD LOAD" one by one (they have some differences). At the end I have the table I want and can easily explain how to add the future one to my colleagues with the "ADD LOAD" commented above. However i can't manage to add an ID to every row since it reapeat itself when i put it at every table and dosn't cover every row if i put it at the begining/end.

Here's a demonstration :

table1:

LOAD * INLINE [
Field1, Field2
a, b
c, d
e, f
];

ADD LOAD * INLINE [
Field1, Field2
g, h
i, j
k, l
];

How can i add an ID to the final result of this (the files are really big) ?

Re: Add a Rowno() on many added tables

sunny_talwar — Wed, 23 Sep 2020 12:54:17 GMT

So, for the sample above you want the row numbers to be 1 to 6, right? It seems to work when I use RowNo(). If you want 1 to 3, you can use RecNo()

table1: LOAD RowNo() as RowNo, RecNo() as RecNo, *; LOAD * INLINE [ Field1, Field2 a, b c, d e, f ]; Concatenate(table1) LOAD RowNo() as RowNo, RecNo() as RecNo, *; LOAD * INLINE [ Field1, Field2 g, h i, j k, l ];

Re: Add a Rowno() on many added tables

Antoine553 — Wed, 23 Sep 2020 13:13:25 GMT

thanks a lot