Question
Flextronics
IN
Posted: Mar 12, 2018
Last activity: Mar 13, 2018
Last activity: 13 Mar 2018 7:30 EDT
This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.
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://collaborate.pega.com/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
I would like to put it in a data table as I think that will be the fastest way to loop through Excel.
Can 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? )
No I would like to do a lookup and fill values on an Excel sheet.
Are you talking about having a lookup on the Excel Sheet or within PRPC ?
Hey I'm talking about a lookup on Excel.
Question
Question
Discussion
Question
Question
Question
Question
Question
Question
Question Solved
Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.