if Excel Cell

[alexandermllr]

Hello

I have this Excel File:

	A	B	C
1	01.08.2016	Data	Data
2		Data	Data
3	02.08.2016	Data	Data
4		Data	Data

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 · Accepted solution]

try like that in script:

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

Hope this helps

[Frank_Hartmann]

Or try:

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

hope this helps

[Anonymous]

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]

Thank you! 

Both answers worked perfectly!