SQL In operator in Qlik sense

[swathidumpala]

Hi,

Can anyone please help me how to use Sql In operator in Qlik sense.

I have to get

load  branch,

name from tableA where branch in (100,200,300,400) ;

[JordyWegman · Accepted solution]

Hi,

You are trying to rephrase the SQL statement to a Qlik statement?

Then use this:

Load
  branch,
  name 
From tableA 
Where Wildmatch(branch,100,200,300,400);

Jordy

Climber

[swathidumpala]

Thanks Jordy,

The below is giving 100,200,300,400 and also one blank (with all other values as one group).

How can we get rid of that bank.

[JordyWegman]

Maybe you can check the solution @sunny_talwar gave here. In combination with the pick you can be able to give all other values the value you want.

Jordy

Climber