Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Purushothaman
Partner - Creator III
Partner - Creator III

WHERE IN CONDITION

Hi Experts,

What is the script for Where IN condition in Data Load editor?  

I am getting error. 

 

Purushothaman_1-1655375397996.png

I don't want to use OR condition, Please suggest me. 

Anyone, Please help.

Thank you

 

 

 

4 Replies
Or
MVP
MVP

There is no IN for Qlik script. In this case, you should use Match(DataSourceWProd,'WEBB','SAP'), most likely.

sidhiq91
Specialist II
Specialist II

Please use match() function.

Match(DatasourceWprod,'WEBB','SAP')

cedfoning
Creator
Creator

hello

 

you should do as follow :

Match(DatasourceWprod,'WEBB','SAP')

 
vinieme12
Champion III
Champion III

if you need to keep optimized load use Exists() function

example

 

KeepSource:
Load * Inline [
DataSourceWProd
WEB
SAP
];


Fact:
Load
*
From Datasourcexyz.qvd
Where Exists(DataSourceWProd) ;

Drop table KeepSource;

 

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.