Reading from Excel sheet

[mario-sarkis]

hi All

please I need your help

i am reading on Qlikview from an Excel Sheet but i am facing a problem.

how can i fill an empty Cell  ex:

  A              B               C

Jul-14
Avg	Int	Rate
12	233	251
32	122	2133
123	131	131

When i Importing this Form the first cell in column B and C is empty

the script will show like this

Directory;

Load

41650,

F2,

F3,

i need to show as

41650,    

41650,

41650

Ps: i cannot change in the form of the excel sheet cause i have almost a hundred excel sheet same form so if i change one i have to change the others so it will take alot of time, i am looking for a solution using Qlikview,

Thank you.

[Gysbert_Wassenaar]

You can use the Transformation options of the File Wizard to fill the empty cells. See attached video.

[mario-sarkis]

Gysbert Wassenaar thank you your Answer is helpful but i just realize that i have this case

41565
21
231	23
21	12

and i need to Show like this

41565	41565
21
231	23
21	12

without filling all Cells just in the first ROW !!

Help PLEASE!!! Can YOU!!!????

[mario-sarkis]

Gysbert Wassenaar thank you your Answer is helpful but i just realize that i have this case

41565
21
231	23
21	12

and i need to Show like this

41565	41565
21
231	23
21	12

without filling all Cells just in the first ROW !!

Help PLEASE!!! Can YOU!!!????

[Gysbert_Wassenaar]

LOAD A,

    if(RowNo()=1,A, B) as B,

    if(RowNo()=1,A, C) as C

FROM [*.xlsx] (ooxml, no labels, table is Sheet1);

[mario-sarkis]

sorry Gysbert For disturbing you

if i have it like this

41565		41253
21		231
231	23	5211	331
21	12	12	16

need to show it like this

41565	41565	41253	41253
21		231
231	23	5211	331
21	12	12	16