topic Re: Loading a list of values from Excel to Variable in QlikView

Loading a list of values from Excel to Variable

Thu, 12 Nov 2015 14:08:14 GMT

Hello QV Community:

Appreciate if someone can kindly help me with the following problem I have:

I have a list of values in Excel (like snap shot below) and I would like to pass these values as parameters

in a script under the "Where" statement like:

Load * from Customer.Table

Where

match(Customer.ID,'A010006','A080478','A082780','A0978256','C088897')

thanks in advance

Kumar

sunny_talwar — Thu, 12 Nov 2015 14:14:05 GMT

May be use where exist instead:

FieldCheck:

LOAD Family

FROM source;

LOAD Customer.ID,

OtherFields

FROM

Where Exists (Family, Customer.ID)

rubenmarin — Thu, 12 Nov 2015 14:21:19 GMT

And if you want to use in a SQL Select you can load those in a variable:

LOAD Chr(39) & Concat(Familia, Chr(39) & ',' & Chr(39)) & Chr(39) as FamilyFilter;

LOAD Family

FROM [...xlsx] ....;

LET vFamilyFilter = FieldValue('FamilyFilter', 1);

Then you can use it in the where:

SELECT ... FROM ...

WHERE Family IN ($(vFamilyFilter));

Thu, 12 Nov 2015 14:48:01 GMT

Thanks Sunny, your suggestion worked !!!

sunny_talwar — Thu, 12 Nov 2015 14:48:17 GMT

Awesome

Thu, 12 Nov 2015 14:49:28 GMT

Thanks Ruben, your suggestion worked too!