Question6Replies654Views AbhinavM8986 Member since 2017 38 posts Flextronics Posted: 2 years agoLast activity: 2 years 6 months ago Closed Export DataHey guys I have a lookup where we import data from a excel sheet into data table. How is it possible to use the same to do a lookup with another table on another sheet? Reporting ×Close popoverFacebookTwitterLinkedinEmail Copy Link Copied! Moderation Team has archived post This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question. Posted: 2 years agoAsif Hasan PEGA replied to AbhinavM8986Hi AbhinavM8986, Thanks for your post on PSC. I would like to understand more about implementation you're having at your end to have a clarity. Could you let me know, 1. How you're importing data from Excel to Pega? 2. What did you mean by lookup here? 3. Could you explain, "How is it possible to use the same to do a lookup with another table on another sheet?" We have an OOTB activity "MSOParseExcelFile" which could be used for the same purpose. Please refer links for implementation details:- - https://pdn.pega.com/community/pega-product-support/question/parse-exce… - https://pdn.pega.com/community/pega-product-support/question/excel-shee… Hope it answers your question, kindly notify if it does by marking this post as answered. Regards, Asif Posted: 2 years agoAbhinavM8986 Flextronics replied to Asif HasanI would like to put it in a data table as I think that will be the fastest way to loop through Excel. Posted: 2 years agoJOHNPW_GCS PEGA replied to AbhinavM8986Can you export your data to a CSV ? Later versions of PRPC allow to import CSV directly into Data tables... (Not sure I have understood your exact use case here though? ) Posted: 2 years agoAbhinavM8986 Flextronics replied to JOHNPW_GCSNo I would like to do a lookup and fill values on an Excel sheet. Posted: 2 years agoJOHNPW_GCS PEGA replied to AbhinavM8986Are you talking about having a lookup on the Excel Sheet or within PRPC ? Posted: 2 years agoAbhinavM8986 Flextronics replied to JOHNPW_GCSHey I'm talking about a lookup on Excel.