Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Autofilling missing values

Need Help!!!

I have data as below:-

i want to fill this column by missing values.

BFU000713
BFU000714
BFU000715
BFU000722
BFU000723
BFU000724

for ex:- thete is difference between BFU000715 and BFU000722 so need to fill it by BFU000716 till BFU000721.

Please find attached for reference

1 Reply
crusader_
Partner - Specialist
Partner - Specialist

Hi,

Use

LOAD *

While

construction with autoincremental IterNo() function.

Hope this helps.

Regards,

Andrei Kaliahin