Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Friends,
Attached is my data in excel.
The first 3 rows are columns in my data, and rest are the data. Could you please help me to know best way to load the data in qvd?
Thanks!
Make sure while loading xl select option Embeded lables .
Hi,
header is 3 lines is the key here:
LOAD A,
B,
C,
D,
E,
F,
G
FROM
(ooxml, no labels, header is 3 lines, table is Sheet1);
HTH.
Hi
Follow these steps:
See attached for an example using your sample.
HTH
Jonathan