topic Dynamically select fields for load in QlikView

Dynamically select fields for load

Jason_Michaelides — Tue, 28 Feb 2012 16:58:43 GMT

Hi all,

Can anyone help me with some load script that loads a list of required fields from a spreadsheet and then only load these fields from a QVD that will have many more fields in it?

Cheers,

Jason

Re: Dynamically select fields for load

john_duffy — Tue, 28 Feb 2012 17:43:35 GMT

Hi Jason.

You may be able to accomplish this using the FieldName function. See the attached application.

Let me know if this helps.

John.

Dynamically select fields for load

Tue, 28 Feb 2012 17:53:17 GMT

Try this:

Temp:

LOAD

concat(FieldsToLoad, '],[') AS FieldsToLoad

FROM myexcel.xlsx

(ooxml, embedded labels, table is Sheet1) ;

LET vFieldList = '[' & peek('FieldsToLoad') & ']';

Data:

LOAD

$(vFieldList)

FROM myqvd.qvd (qvd);

DROP TABLE Temp;

Re: Dynamically select fields for load

Jason_Michaelides — Tue, 28 Feb 2012 18:38:00 GMT

Hi Matt,

That looks pretty logical! I'll try it when I'm next at my PC and let you know. Looks like it'll work though.

Cheers,

Jason

Re: Dynamically select fields for load

Jason_Michaelides — Wed, 29 Feb 2012 09:39:26 GMT

Thanks John but as far as I can see your solution will still require a change in the script to change which fields from the QVD were to be loaded.

Jason

Re: Dynamically select fields for load

Jason_Michaelides — Wed, 29 Feb 2012 09:39:50 GMT

Matt - works like a charm. Thanks loads mate. I just added a WHERE [Load?]='Y' clause to the temp table load and now the administrators can define which fields they want in the data model!

Jason

Message was edited by: Jason Michaelides (expanded).

Dynamically select fields for load

Wed, 29 Feb 2012 10:41:54 GMT

Glad it worked!