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

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
Output1
Output2

please help me with the solution

Hi @nishant.pandey

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

image

Then use Filter Activity to remove unwanted columns

image

Cheers

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