I have input data received from user in excel format and converted into clipboard page.Only one column in the excel input needs to be updated in table.Before updating the table that I need to check whether the input row data matches with table row data or not.If it match then I should update a single column in table.If the input row data not found in table,I need to show error message that we can't insert new rows in table.

I have tried this requirement using Page loop in Activity/DT. It is working but the issue is with performance.The excel can have 500 - 10k records.So could you please suggest any other solution to achieve this? can we use dataflows for this?

Pega Version 8.3 - customer decisioning hub