Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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