How to add remarks only to the blank cells?

Hi All,

I’m currently automating a payment process. The user says he will be giving the input in an Excel file.

He wants to use the same file forever, since he wants to look for duplicates in four columns and remark as “Skipped”.

If values in two columns matches, I should remark as “Recheck”

If values in one column matches, I should remark as “Duplicate”

Please refer the attached Excel file for better understanding.

INPUT.xlsx (10.3 KB)

“TransactionData” is the output of the Excel Read Range. I use these expressions to take the entries with blank remarks.


Then look for duplicates and add the required remarks.

If there’s a success remark, it becomes blank. I should add remarks only to the cells which is blank. But need to look for duplicates in the whole excel file.

Please help me with this.

Hi @tokio_marine

Use a filter datatable with the current transaction details of which you need to search for duplicates and filter the original table and check the count of rows returned,…If count>1 then it is a duplicate row

cheers

Hi @tokio_marine

I suggest you should copy this data table in other data table and try to loop both by DT with condition on Remark column and use add data row and update remark value.

thanks