Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
What is the script for Where IN condition in Data Load editor?
I am getting error.
I don't want to use OR condition, Please suggest me.
Anyone, Please help.
Thank you
There is no IN for Qlik script. In this case, you should use Match(DataSourceWProd,'WEBB','SAP'), most likely.
Please use match() function.
Match(DatasourceWprod,'WEBB','SAP')
hello
you should do as follow :
Match(DatasourceWprod,'WEBB','SAP')
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;