Field not found error

[Anonymous]

DNI:

Load

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

     Mod(NumeroDNI, 23) as LetraDNI   

AutoGenerate (20);

Field 'NumeroDNI' not found

I

[sunny_talwar · Accepted solution]

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]

The mod doesn't work. Thanks

[sunny_talwar]

What exactly are you hoping it would do?