Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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

Community Browser