Qlik Community

Qlik Education Discussions

Discussion Board for collaboration related to Qlik Education.

mario-sarkis
Contributor

Reading from Excel sheet

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
AvgIntRate
12233251
321222133
123131131

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.

5 Replies

Re: Reading from Excel sheet

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


talk is cheap, supply exceeds demand
mario-sarkis
Contributor

Re: Reading from Excel sheet

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

41565
21
23123
2112

and i need to Show like this

4156541565
21
23123
2112

without filling all Cells just in the first ROW !!

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

mario-sarkis
Contributor

Re: Reading from Excel sheet

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

41565
21
23123
2112

and i need to Show like this

4156541565
21
23123
2112

without filling all Cells just in the first ROW !!

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

Re: Reading from Excel sheet

LOAD A,

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

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

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


talk is cheap, supply exceeds demand
mario-sarkis
Contributor

Re: Reading from Excel sheet

sorry Gysbert For disturbing you

if i have it like this

41565 41253
21 231
231235211331
21121216

need to show it like this

41565415654125341253
21 231
231235211331
21121216
Community Browser