Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
jasonseril
Creator
Creator

Load Excel with merged row cell data

Hello All,

I have an excel data (please see below), with merged rows cell,

mergeddata.PNG

Please help which load script should i use, so that when load it will look like this (please see below)?

qvwload.PNG

thanks in advance.

BR.

Jason

1 Solution

Accepted Solutions
tamilarasu
Champion
Champion

Hi Jason,

Try,

Data:

LOAD If( IsNull(a), Peek(a),a) as a,

     b,

    c

FROM

Book2.xlsx

(ooxml, embedded labels, table is Sheet1);

Or

Data:

LOAD a,

     b,

     c

FROM

Book2.xlsx

(ooxml, embedded labels, table is Sheet1);

NoConcatenate

Load *,

If( IsNull(a), Peek(a),a) as NewValue

Resident Data;

Drop Table Data;

View solution in original post

2 Replies
tamilarasu
Champion
Champion

Hi Jason,

Try,

Data:

LOAD If( IsNull(a), Peek(a),a) as a,

     b,

    c

FROM

Book2.xlsx

(ooxml, embedded labels, table is Sheet1);

Or

Data:

LOAD a,

     b,

     c

FROM

Book2.xlsx

(ooxml, embedded labels, table is Sheet1);

NoConcatenate

Load *,

If( IsNull(a), Peek(a),a) as NewValue

Resident Data;

Drop Table Data;

jasonseril
Creator
Creator
Author

Hello Tamil,

Thank you much!

Best

Jason