query

[Anonymous]

i have a requiremnt where i need to assign a numbers to the given field ,but also it shud reset if the field value changes?

by whuch command we can do that?

[VishalWaghole]

Can you please provide some test data, which will help us to understand your requirement.

[antoniotiman]

Hi,

You can use Autonumber() in script

LOAD *,AutoNumber(FieldA) as AutoNr Inline [
FieldA,B
A,1
A,2
A,3
B,4
B,5
B,6
];

Regards,

Antonio

[antoniotiman]

or

LOAD *,AutoNumber(RowNo(),FieldA) as AutoNr Inline [
FieldA,B
A,1
A,2
A,3
B,4
B,5
B,6
];