Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
ali_hijazi
Partner - Master II
Partner - Master II

adding rows during load

Hello

I got a table that contains the following sample data ; dates are in the format of DD/MM/YYYY

Item    Date            UnitRetail

A        12/1/2012     500

A         15/2/2012    450

A        23/4/2012     400

B       1/1/2012        560

....

what I want is during loading data from database fill the gaps by the last unit retail

i.e.

for Item A I want to fill the dates from 13/1/2012 till 14/2/2012 with the unit retail of 500

and then from 16/2/2012 till 22/4/2012 fill rows with unit retail 450

and then from 24/4/2012 till 31/12/2012 fill rows with unit retail 400

and so on....

is this possible?

Please advise

I can walk on water when it freezes
2 Replies
jagan
Luminary Alumni
Luminary Alumni

Hi,

You can do this, by using AutoGenerate and For loop OR LOAD ....WHILE.

Try this options.

Regards,

Jagan.

ali_hijazi
Partner - Master II
Partner - Master II
Author

How?

can u give me an example based on the above sample data

I can walk on water when it freezes