Janani Nanthakumar (JananiN7)

JananiN7 Member since 2015 3 posts
Posted: February 16, 2021
Last activity: February 16, 2021
Posted: 16 Feb 2021 5:16 EST
Last activity: 16 Feb 2021 7:43 EST

Comparing Excel data with table data

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


***Edited by Moderator: Pooja Gadige to add platform capability tag***
Pega Customer Decision Hub 8.3 Decision Management Data Integration