Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
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;

Highlighted

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