topic Re: Struggling with load statement coding in QlikView

Struggling with load statement coding

twills12 — Wed, 25 Nov 2020 16:16:04 GMT

I have data being populated in an excel form such as this that I'm loading into my application...

column A
Field A: This is the data for Field A.
Field B: Some other data is populated here.
Field C: Still some other data to be found here.
Field 😧 Yet other data here.
...
...
Field X: Something more here.

I would like to structure the load so that I have a resulting table such as this...

Field A	Field B	Field C	Field D	Field X
This is the data for Field A.	Some other data is populated here.	Still some other data to be found here.	Yet other data here.	Something more here.

Any suggestions appreciated!

Re: Struggling with load statement coding

Nicole-Smith — Mon, 26 Feb 2018 23:12:12 GMT

Load script like this:

Temp:
LOAD * INLINE [
column A
Field A: This is the data for Field A.
Field B: Some other data is populated here.
Field C: Still some other data to be found here.
Field 😧 Yet other data here.
Field X: Something more here.
];


FOR i=1 TO NoOfRows('Temp')


 LET Field = '[' & SUBFIELD(PEEK('column A', $(i)-1, 'Temp'), ': ', 1) & ']';
 LET Value = CHR(39) & SUBFIELD(PEEK('column A', $(i)-1, 'Temp'), ': ', 2) & CHR(39);
 
 IF $(i) = 1 THEN 
      Data:
      LOAD $(Value) AS $(Field)
      AutoGenerate 1;
 ELSE 
      LEFT JOIN (Data)
      LOAD $(Value) AS $(Field)
      AutoGenerate 1;
 ENDIF


NEXT

Will return a table that looks like this:

Field A	Field B	Field C	Field D	Field X
This is the data for Field A.	Some other data is populated here.	Still some other data to be found here.	Yet other data here.	Something more here.

Re: Struggling with load statement coding

twills12 — Tue, 27 Feb 2018 16:06:07 GMT

Thanks Nicole!!!