Comparing queue data with excel data to check if queue data is not present in excel

Hi team,
I have queue with data like name=Sandhya magar same as in excel i have Name column with name sandhya magar now i want to check if my queue name is not present in excel then do action.can anybody help me out?

Hi @Sandhya_Gajare ,

Step1 : Add “Get Transaction” activity. specify queue name and assign a output variable for eg Transactionitem
Step2 : Add in assign the below expression
str_Name=Transactionitem.specificontent(“ColumnName”).tostring
Step 3 : Add filter datatable activity and provide str_Name in column filter

Please try and let me know if it works for you

(strReverseString.Contains(CurrentRow(“Name”).ToString)) And CurrentRow(“Eligible”).Tostring.Contains(“Y”) i am checking like this how can i check for empty

1 Like

HI @Sandhya_Gajare

Could you please let me know if you want to check if the string is empty or if the filtered datatable is empty?

To check if filtered results are empty you can use the below expression in if condition
(from row in dt_datatablevariable where striReverseString.contains(row(“Name”).tostring) and row(“Eligible”).tostrin.contains(“Y”) Select row ).count>0