Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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;
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.
thank you