Moving the Unmatched row into another sheet in Excel

Help
1

Hi Everyone,

can someone please help me to to achieve the following condition.

TestNed1
TestNed11116×346 29 KB

Need only two records (rows) of the same TXN NUMBER. If there is a third row with same TXN NUMBER need to check the “CREDIT AMOUNT” Column AND “DEBIT AMOUNT” Column Value must be same. If not matched that row needs to be moved to another sheet.

Attached Excel: Test.xlsx (9.2 KB)

Much appreciated for your kind help in advance.

Kind Regards
Vishnu

2

Hi @winningvish

Based on the condition

Use build datatable

Use add data row

Thanks
Ashwin.S

3

Hi @AshwinS2,

Thank you for your quick reply.

Would you please more elaborate.

Attached workflow: Main.xaml (7.0 KB)

Regards
Vishnu