Use of recNo() and Concatenate

[alec1982]

hi guys,

I am using recNo() on one of my tables. then i am doing Concatenate to add more data from different table.

Now the recNo() is causing duplicates. Do you know how to make recNo() continue after the last value from the first table.

My script

Table1:

recNo() as ID,

Amount

From ABC;

Concatenate (Table1)

recNo() as ID,

Amount

From XYZ;

[hic · Accepted solution]

Yes, use RowNo() instead.

HIC

[hic]

See more on http://community.qlik.com/blogs/qlikviewdesignblog/2013/09/16/counters-in-the-load

HIC

[alec1982]

Thank you!