How to achieve the function in "Load" statement, w... - Qlik Community

Anonymous · ‎2011-07-12

How to achieve the function in "Load" statement, which "in" like SQL?

For example:

Load *,if(InsCode in $(vInsCode),1,0) as Flag from Fact.qvd(QVD);

$(vInsCode)=('0021','33A1','4263',......)

If the InsCode equal '0021' or '33A1' or '4263' or ....,I want to flag this row by a new column named Flag.

And "vInsCode" is a variable.

kaushiknsolanki · ‎2011-07-12

Hi,

Try this way.

Load *

from XYZ

where wildmatch(InsCode,'0021','33A1','4263',......);

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

Miguel_Angel_Baeyens · ‎2011-07-12

Hi,

Use the conditional with the match() function to create the flag

Table:
LOAD *,
     If(Match(InsCode, $(vInsCode)) > 0, 1, 0) AS Flag
FROM Fact.qvd (qvd);

Make sure that $(vInsCode) has all possible values single quoted and comma separated.

Hope that helps.

BI Consultant