Load Excel with merged row cell data

[jasonseril]

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 · Accepted solution]

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]

Hello Tamil,

Thank you much!

Best

Jason