topic Re: Adding a field to a table in QlikView

Adding a field to a table

Anonymous — Thu, 21 Jul 2016 14:12:34 GMT

I have a table. For the sake of example, let's say it's created like so:

MyTable:

LOAD Myfield1, Myfield2, Myfield3

RESIDENT SomeOtherTable;

I wanted to add a sequential record number to the table, so I tried this:le:

MyNewTable:

LOAD *, RECNO() as RecordID

RESIDENT MyTable;

It added the RecordID field, but it used seemingly random values - 4, 8, 11, 15 instead of the expected 1,2,3,4.

In order to get the desired result, I had to do this:

MyNewTable:

LOAD Myfield1, Myfield2, Myfield3, RECNO() as RecordID

RESIDENT MyTable;

I consider this to be a bug (among the many other bugs your product has). Oh wait, the trainer refused to call stuff like this a "bug", preferring instead to call it a "nuance".

Re: Adding a field to a table

Anonymous — Thu, 21 Jul 2016 16:49:05 GMT

Use Rowno() instead of RECNo()

Re: Adding a field to a table

sunny_talwar — Thu, 21 Jul 2016 16:49:18 GMT

Is there a where statement when you did a resident load??

What do you get when you use RowNo() instead of RecNo()?

MyNewTable:

LOAD *, RowNo() as RecordID

RESIDENT MyTable;

Re: Adding a field to a table

vikramv — Thu, 21 Jul 2016 16:53:26 GMT

Try using the rowno() instead of record number.

RecNo or RowNo?

Re: Adding a field to a table

MarcoWedel — Thu, 21 Jul 2016 22:40:46 GMT

Hi,

do you have a sample application+data to demonstrate the issue?

This example doesn't seem to show this behaviour:

MyTable:
LOAD RecNo() as Myfield1,
    Ceil(Rand()*100) as Myfield2,
    Ceil(Rand()*100) as Myfield3
AutoGenerate 20;

MyNewTable:
LOAD *, RECNO() as RecordID
RESIDENT MyTable;

DROP Table MyTable;

thanks

regards

Marco