Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

leechanhee
New Contributor II

merged data vertically

캡처.PNG        2.PNG

                              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.

Labels (1)
3 Replies

Re: merged data vertically

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;

Re: merged data vertically

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
New Contributor II

Re: merged data vertically

thank you

Community Browser