AutoGenerate in nested Load

[#1]

Can someone explain why this statement:

load
  a;
load
  RowNo() as a
AutoGenerate(10);

behave like this:

?

[#2]

Hi

PFA...

[#3]

I don't understand your point.

[arbernardez_old · Accepted solution]

Hello,

You may use RecNo() instead RowNo()

Load

A

;

LOAD

RecNo() as A

autogenerate(10);

Regards

[#5]

Thanks. Now i see what is wrong hire.

[#6]

See my script

A:

LOAD * Inline [

A,Name,Sales

1,Nirmal,1000

];

LOAD

RecNo() as A

autogenerate(10);

[hic]

RowNo() is only defined in the topmost Load statement. So, either you move your RowNo() to this Load, or you use the RecNo() function instead.

HIC