loading data in QlikView

[#1]

Hi All,

I have some data that I need to transform during load, is there an easy way to achieve this in Qlik?

My data looks like this:

Date	Amount
31/10/2011
30/11/2011
31/12/2011
16/01/2012	38,008.35
31/01/2012
29/02/2012
31/03/2012
16/04/2012	36,417.00

Where the amount is null for the date, I want to populate it with the next future amount, like this:

Date	Amount
31/10/2011	38,008.35
30/11/2011	38,008.35
31/12/2011	38,008.35
16/01/2012	38,008.35
31/01/2012	36,417.00
29/02/2012	36,417.00
31/03/2012	36,417.00
16/04/2012	36,417.00

I thought about intervalmatch but haven't been able to get the results I'm after.

Any help would be very much appreciated.

Kind Regards,

Phil

[#2]

Hi,

use the table wizard and select your table.

Then follow the steps documented in the screenshots (see the attached ZIP file).

Good Luck!

Rainer

[lironbaram · Accepted solution]

hi

check the attach example

it uses the load script to fill the data

[#4]

Thanks Rainer, very helpful I had no idea Qlik could do that!

It did do something odd though with filling column headers where the first couple of rows were blank. Though I could work round that by specifying the first row as a header line.

Thanks again, Phil.

[#5]

Thanks Liron, it's a neat solution to put that in the script.

Kind Regards,

Phil