topic Re: Load Excel with merged row cell data in QlikView

Load Excel with merged row cell data

jasonseril — Fri, 20 Nov 2015 07:02:27 GMT

Hello All,

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

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

thanks in advance.

BR.

Jason

tamilarasu — Fri, 20 Nov 2015 07:09:21 GMT

Hi Jason,

Try,

Data:

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

FROM

Book2.xlsx

(ooxml, embedded labels, table is Sheet1);

Data:

LOAD a,

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 — Fri, 20 Nov 2015 07:16:38 GMT

Hello Tamil,

Thank you much!

Best

Jason