Auto generate field

[#1]

Hi,

I want to QV to generate an ID field automatically. I am using the below function.

E' & AutoNumber(entity_name)  as entity_id

This would generate E1, E2, E3,........, E999 etc.

Is there any way I can get these generated as E001,...........,E999 etc. ?

[Anil_Babu_Samineni]

Yes, You can

LOAD 'G' & AutoNumber(RowNo(),1000) as RowNo

AutoGenerate 999;

Or

Load 'G' & AutoNumber(RowNo(), entity_name) as entity_id

[daveamz · Accepted solution]

Hi,

Yes. Use 'E' & Num(AutoNumber(entity_name), '000') as entity_id

Regards,

David

[qlikview979]

Hi,

try like this

T1:

LOAD

'E' & Num(AutoNumber(RecNo()), '000') as REC

AutoGenerate 999;