topic Re: Data Load in QV script in QlikView

Data Load in QV script

Thu, 09 Oct 2014 07:41:05 GMT

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!

Anonymous — Thu, 09 Oct 2014 07:44:49 GMT

Make sure while loading xl select option Embeded lables .

salto — Thu, 09 Oct 2014 08:32:08 GMT

Hi,

header is 3 lines is the key here:

LOAD A,

FROM

(ooxml, no labels, header is 3 lines, table is Sheet1);

HTH.

jonathandienst — Thu, 09 Oct 2014 09:28:34 GMT

Follow these steps:

transpose load the first 3 rows (as colummns) using a fill down for the blanks
create a name mapping table to map column letters to concatenated names from the header rows
load the data without headers
Rename the fields using the map

See attached for an example using your sample.

HTH

Jonathan