Posted: 13 Jun 2017 5:47 EDT Last activity: 6 Nov 2018 20:02 EST
How to filter the data from Excel sheet in openspan
Could you please let us know the easiest way to filter the data from the data from excel sheet. Any other alternatives that are provided in openspan.
In the Automation attached in the snapshot I am trying to read the data from excel and load it into lookup table and then want to load this lookup table into tableview and from here trying to filter the data and then load into gridview or into another excel sheet. But I am struck up at initial loading of data exporting from excel to lookup table am getting error. Please help me what I am missing here.
Please find the attached snapshots of Automation and Excel sheet and the error.
**Moderation Team has archived post**
This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.
The problem is that the table you are exporting does not have columns named the same as your Lookup Table. The simplest way to fix this is to add headers to your Excel sheet that match your columns in the Lookup Table. Then change your export to include the header row - make CreateHeader true - this will cause the table columns to be named by the headers. Once the output table from your export matches your Lookup Table, the rest of your automation should work.
Thanks for the reply, I am able to load the data into lookup table now. If any details please let me know about how to filter the data after passing the data to lookup table to table view or let me know any other alternatives for filtering the data from Excel and load it.
Thank you for posting your query on PSC. This looks like an inactive post and hence, we suggest you create a new post for your query. Click on the Write a Post button that’s at the top of our Pega Support Community homepage. Once created, please reply back here with the URL of the new post.
We have also sent you a private message opening up a communication channel in case you have any further questions.