I am using MSOParseExcelFile to upload the Excel data to a clipboard page list(For example: EmpNum,EmapName and EmpCity). Upto this it's working fine. Next I need to Query external table in an activity to fetch all the records matching the clipboard values Along with other fields. What's the optimal way to achieve this. Please help me in this regard
I assume you mapped the external table to a class in Pega (if not use connector and meta data accelerator wizard to map external table to Pega class). To achieve your scenario, loop through each page list and do Obj-browse (You can use RDB-List as well) by passing EmpNum,EmapName and EmpCity to get the additional fields.