Solved: Automatic generation of serial Numbers - Qlik Community

wood · ‎2020-09-29

hi all

How do You generate field 2 from field 1 in a script

Filed1, Filed2
A, 1
B ,1
B ,2
C, 1
C, 2
C, 3
D ,1
D ,2

Anil_Babu_Samineni · ‎2020-09-29

Try this

LOAD *, AutoNumber(RecNo(), Filed1) as Filed2 Inline [
Filed1
A
B
B
C
C
C
D
D
];

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

View solution in original post

Anil_Babu_Samineni · ‎2020-09-29

Try this

LOAD *, AutoNumber(RecNo(), Filed1) as Filed2 Inline [
Filed1
A
B
B
C
C
C
D
D
];

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

wood · ‎2020-09-29

Good, thank you very much!