Close popover
Sruthi Ambati (SruthiA1487)
Cigna Corporation

Cigna Corporation
SruthiA1487 Member since 2018 8 posts
Cigna Corporation
Posted: July 21, 2020
Last activity: July 21, 2020

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


Robotic Process Automation Reporting Healthcare and Life Sciences