Loading a list of values from Excel to Variable

[#1]

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]

May be use where exist instead:

FieldCheck:

LOAD Family

FROM source;

LOAD Customer.ID,

          OtherFields

FROM

Where Exists (Family, Customer.ID)

[rubenmarin]

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));

[#4]

Thanks Sunny, your suggestion worked !!!

[sunny_talwar]

Awesome

[#6]

Thanks Ruben, your suggestion worked too!