Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Data Load in QV script

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!


3 Replies
Anonymous
Not applicable
Author

Make sure while loading xl    select option Embeded lables .

salto
Specialist II
Specialist II

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.

jonathandienst
Partner - Champion III
Partner - Champion III

Hi

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein