hard code ID

[nareshthavidishetty]

Hi,

We need to create an ID like

ID = 90001,90002,9003...................

I have used 9000+rowno()

but it gives some random results like 9006,90010......

Thanks..

[sunny_talwar]

May be try with RecNo() and see if that helps?

9000 + RecNo()

[jonathandienst]

Do you mean in script or in a chart/table?

[nareshthavidishetty]

In Script

[nareshthavidishetty]

Hi,

Both gives same results.

Please find below.

Thanks..

[jonathandienst · Accepted solution]

Then it would seem that something is removing the other lines, such a a join later in the script.

RowNo() is a count of the output from the load statement. RecNo() is a count of the input and can be affected by a where clause.

I suggest that you post more information about your load script if you would like more detailed help.

[sunny_talwar]

Do you have where clause or Left/Right Joins/Keeps?

[nareshthavidishetty]

yes! We have left join.