How to make bulk files from data table where the first column having similar value but changes in second column

[nishant.pandey]

If [Amount] column change then i have to cut all the changed rows and make other data table for that
so if [AgreementId] value is similar and [Amount] column value change then i have to separate them to other data table.
Input|281x402

[nishant.pandey]

please help me with the solution

[rikulsilva (Henrique Lima da Silva)]

Hi @nishant.pandey

If both Data Table having the Amount column to compare, you can use Join Data Tables Activity like this

Then use Filter Activity to remove unwanted columns

Cheers

[nishant.pandey]

@rikulsilva I have only one data table, from that I need to extract data where amount column has different amounts per AgreementID column