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.

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


Then use Filter Activity to remove unwanted columns



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