merged data vertically

[leechanhee]

       

                              excel                                                         After loading

If the load is kind merge excel spaces , the spaces How do I handle this? There must fill in the data space just above.

[sunny_talwar]

Do you want to see the extra spaces after the data is loaded? If yet try adding a SET Statement in your load

SET  Verbatim=1;

[tamilarasu]

Hi Lee

Like below,

Data:

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

    b,

    c

FROM

Book2.xlsx

(ooxml, embedded labels, table is Sheet1);

Check the below thread.

Load Excel with merged row cell data

[leechanhee]

thank you