Skip to main content

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.

Question

 Jyothirmayi Nerella (JyothirmayiN)
Infosys

Infosys
IN
JyothirmayiN Member since 2017 10 posts
Infosys
Posted: Jun 13, 2017
Last activity: Nov 6, 2018
Posted: 13 Jun 2017 5:47 EDT
Last activity: 6 Nov 2018 20:02 EST
Closed

How to filter the data from Excel sheet in openspan

Hi Team,

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.

Regards,

Jyothi


**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.

To see attachments, please log in.
Robotic Process Automation

Posted: 7 years ago
Posted: 13 Jun 2017 8:24 EDT
Jeff Badger (jeffbadger)
PEGA
Principal Product Manager, Robotics
Pegasystems Inc.
US

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.

Check out my Excel  post for more information.

To see attachments, please log in.
Posted: 7 years ago
Posted: 13 Jun 2017 9:51 EDT
Jyothirmayi Nerella (JyothirmayiN)
Infosys

Infosys
IN

Hi Jeff,

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.

To see attachments, please log in.
Posted: 7 years ago
Posted: 13 Jun 2017 23:42 EDT
Jeff Badger (jeffbadger)
PEGA
Principal Product Manager, Robotics
Pegasystems Inc.
US

To filter a TableView add a Filter statement.  Then when you use the ApplyFilter method you can filter the table.

Once you have filtered the data, you can use the column properties to access the values of the row.

To see attachments, please log in.
Posted: 6 years ago
Posted: 16 Jul 2018 8:55 EDT
Lochana Durgada Vijayakumar (Lochan_DV)
PEGA
Senior Manager, Knowledge Management
Pegasystems Inc.
IN
Hello!
 
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.
Show More
Hello!
 
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.
 
Thanks,

Show Less
To see attachments, please log in.

We'd prefer it if you saw us at our best.

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.

Close Deprecation Notice