Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
An issue has been identified on Qlik Cloud hub, please visit our Status Update Page for details: GET THE LATEST
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