Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
jasonseril
Contributor

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

Re: Load Excel with merged row cell data

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;

2 Replies

Re: Load Excel with merged row cell data

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
Contributor

Re: Load Excel with merged row cell data

Hello Tamil,

Thank you much!

Best

Jason