topic Re: RecNo() in QlikView

RecNo()

Tue, 30 Jun 2015 18:42:56 GMT

Hi,

I have the below

distinct %B

usinessDate,

RecNo() as Rowid

//Group by %BusinessDate

Resident SMI_Collateral;

What I need to do is get unique days from the table and then assign an id so

1 01 jab 2015

2 02 jan 2015

Unfortunately, it duplicates the data, I need something a group by. I know I can do it i first get the unique date and then second step do the insertion into second temp table but should be way just to get the unique values with an incremental id next?

Thank you.

Re: RecNo()

marcus_sommer — Tue, 30 Jun 2015 18:51:54 GMT

Maybe you need rowno - RecNo or RowNo?

- Marcus

Re: RecNo()

TKendrick20 — Tue, 30 Jun 2015 19:01:12 GMT

Try RowNo. Or, depending on where your data is coming from in the first place you could use IDENTITY(1,1) in a SQL SELECT to get similar functionality.

Re: RecNo()

hic — Tue, 30 Jun 2015 19:08:42 GMT

It sounds like you should use Autonumber()... See Counters in the Load

HIC