topic Re: Field not found error in QlikView

Field not found error

Anonymous — Mon, 05 Feb 2018 08:39:04 GMT

DNI:

Load

Num(100000000*Rand(), '##.###.###') as NumeroDNI,

Mod(NumeroDNI, 23) as LetraDNI

AutoGenerate (20);

Field 'NumeroDNI' not found

sunny_talwar — Mon, 05 Feb 2018 16:37:41 GMT

Since you are still in the same load, you cannot really use the field name.... you have 2 options

1) Use the actual field script

DNI:

LOAD

Num(100000000*Rand(), '##.###.###') as NumeroDNI,

Mod(Num(100000000*Rand(), '##.###.###'), 23) as LetraDNI

AutoGenerate (20);

2) Employ Preceding load

DNI:

LOAD *,

Mod(NumeroDNI, 23) as LetraDNI;

LOAD

Num(100000000*Rand(), '##.###.###') as NumeroDNI

AutoGenerate (20);

Anonymous — Tue, 06 Feb 2018 07:45:12 GMT

The mod doesn't work. Thanks

sunny_talwar — Tue, 06 Feb 2018 16:11:08 GMT

What exactly are you hoping it would do?