topic Generate a Unique Value to replace null in QlikView

Generate a Unique Value to replace null

darrellbutler — Fri, 21 Jun 2013 13:32:46 GMT

Hi,

I have a table that contains null values, I need to populate this field with a random number in order for it to fit into my link table.

Can anybody recommend the best loop approach to do this, my table does contain a min and max order number that I could use to control the loop.

Rgds

Gysbert_Wassenaar — Fri, 21 Jun 2013 13:48:38 GMT

Something like this maybe:

Table1:

Load

FieldA

,FieldB

,FieldC

,if(len(trim(MyField))=0, autonumber(rand()),MyField) as MyField

From ...somesource...;

Fri, 21 Jun 2013 13:49:53 GMT

Hi,

Try autonumber() or RecNo() or RowNo() Functions...

Rebeca

darrellbutler — Fri, 21 Jun 2013 15:24:14 GMT

Thanks guys, is there anyway you can dictate the starting number in an autonumber command, for example I might not want it to start at 1.

Rgds

Darrell