Save data to Excel from load Script

[harsha]

Hello Experts,

I have loaded my data from QVD and made some changes to create some flags based on some criteria. I want to save data into Excel from load script but not the entire data but based on one dimension Categories

Ex: here I want to save where Category= Stable, Increase ,Decrease but not Extreme.

CompanyID	ProductID	Year	Value	Category
123	C34	2019	100	Stable
123	C32	2020	130	Increase
452	C34	2018	90	Decrease
452	C32	2019	120	Stable
879	C34	2019	110	Stable
879	C32	2020	155	Extreme

I am using below script to save only one Category but how to give multiple Categories ?

where match (Category,'Not in From System');
store Excel_Test into [lib://QVD_Transform/Qlik_Data_Test.csv] (TXT) ;

[Taoufiq_Zarra · Accepted solution]

@harsha  if I understood correctly

where match (Category,'Not in From System','Stable','Increase','Decrease')>0;

....

[harsha]

yes.. this works @Taoufiq_Zarra  Thank u 🙂