I have to use match function to filter data in the script part. However i dint want to hard code values since they change everyday. Can anyone please help me understand to do them automatically using variables?
Please find attched file where i described the problem.
It might be easier to use the Exists() function to check against your field loaded from Excel:
Load * Inline [
4, 500 ];
//****Assuming below ID data is coming from external file and they keep changing****
Load ID as IDCheck inline [
where Exists(IDCheck, ID); //match(ID,'1','3');
drop table Test; // instead of harcoding ID values 1 and 3 is there any way get them inside match function using varibale?? like mentioned above ID's will be maintined in external file and will be chnaging and we cant hardcode them everyday