Question
6
Replies
696
Views
Flextronics
Posted: March 12, 2018
Last activity: March 13, 2018
Closed
Export Data
Hey 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?
Hi @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-excel-data-pega
- https://pdn.pega.com/community/pega-product-support/question/excel-sheet-parsing
Hope it answers your question, kindly notify if it does by marking this post as answered.
Regards,
Asif