topic Re: if Excel Cell in QlikView

if Excel Cell

alexandermllr — Fri, 02 Dec 2016 08:36:20 GMT

Hello

I have this Excel File:

The Cell A2 needs to have the date from A1 and

the Cell A4 needs to have the date from A3. And so on.

I hope someone can help me with this problem!

Thank you!

Frank_Hartmann — Fri, 02 Dec 2016 09:45:36 GMT

try like that in script:

if(isnull(A), peek('A', - 1), A) as A

Hope this helps

Frank_Hartmann — Fri, 02 Dec 2016 09:59:45 GMT

Or try:

if((A)='', peek('A', - 1), A) as A

hope this helps

Anonymous — Fri, 02 Dec 2016 10:09:55 GMT

Hi Alexander,

This can be done while loading data. please find the below steps for the same

Step 1: In load script, load excel file. "Table Files..." -> Select the file and click next

Step 2: Click on "Enable Transformation Step"

Step 3: select "Fill" option., select the option according to your requirement and click ok

Step 4: Click next and finish

alexandermllr — Fri, 02 Dec 2016 15:10:59 GMT

Thank you!

Both answers worked perfectly!