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

 Sruthi Ambati (SruthiA1487) Cigna Corporation
Cigna Corporation
IN
SruthiA1487 Member since 2018 8 posts
Cigna Corporation
Posted: Jul 21, 2020
Last activity: Jul 21, 2020
Posted: 21 Jul 2020 4:47 EDT
Last activity: 21 Jul 2020 8:40 EDT
Closed

How to filter with column name of the table view/Excel having multiple words with space in between.

I have an excel sheet which need to be filtered with specific column data.So I exported data to a tableview using lookup table but there is an issue while adding filter to it.

For example: Column name is "Milestone Group" and one of its values is Sales duties by which I have to search. 1. How to add Filter = 'Milestone Group' having space? On adding as shown and providing value = 'Sales Duties'[tableview filter parameter]. I got an error as, "Syntax error: "Missing operand after 'Group' operator."

2. In case column names of sheet have braces, then in such cases how to add column name to filter.For example column names are Product(s), Excl Product(s).

    Milestone Group|Product(s)|Excl Product(s)| 1. Receive BNCA| Apple, Ipod, Sales| Sales|

***Edited by Moderator: Pallavi to move from Pega Academy to Product, update platform capability tags***

 

To see attachments, please log in.
Robotic Process Automation Reporting Healthcare and Life Sciences

Related content:

Related content has not currently been identified for this post.

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