How to filter the data?

Hello All,

I have scrapped the datatable , it contains 10 rows and add to queue.

I need to check whether a queue item with column “Case Number” is present or not with in the extracted datatable column name “Case Number”

Kindy help on this

@naveen.s ,

You can try this:
Write range the datatable after read range. It will be working well.

Sorry I didn’t get it??

@naveen.s Can you please elaborate more, you have to check whether Case Number Column is present or not?, or Data of that Column?

So that I can help you with your query!

Best regards,
Ajay Mishra

Hi @naveen.s

Below query will give output as boolean if “Case Number” as a item in Queue exist or not considering case sensitivity, If this is what you need.

Variable[boolean] = in_TransactionItem.SpecificContent.any(function(x) x.ToString.Contains(“Case Number”))

Your clarification would be helpful.

Anwar khan.