Hi,
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