topic Re: merged data vertically in QlikView

merged data vertically

leechanhee — Mon, 26 Jan 2026 18:19:17 GMT

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 — Fri, 20 Nov 2015 09:06:47 GMT

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

Hi Lee

Like below,

Data:

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

FROM

Book2.xlsx

(ooxml, embedded labels, table is Sheet1);

Check the below thread.

leechanhee — Tue, 08 Dec 2015 00:26:14 GMT

thank you