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