Validate In Datatable


Please I need your help, I have file is extracted from an application, I save it in a datatable then I need to verify a few things, you have an example of the data below:


1- in the Status column, I need to verify if every processed cell has a transaction number in the previous column, If not I need to save the customer name and number in a variable to send it to the app team.

2- If there is an empty cell in the Status column I need to remove the entire line from datatable

Hi @aalaghbari,

Please use Filter DataTable activity as shown. The resultant DataTable DT only contains the rows that met your filter criteria - status is processed and transaction number empty.


This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.