Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
Filter Person Number Using Copy Paste — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Filter Person Number Using Copy Paste

Accepted answer
14
Views
2
Comments

Summary:

In an OTBI Analysis, is there a way to filter a column based on a copied list of values? For example a column from an excel file or a comma separated list. For example, pasting a Person Number filter of 200 values out of 5,000 would be a lot easier than individually searching for each person.

I tried pasting the values from Excel, but it puts a space between each Person Number, for example 10021; 10897; 90853; 2864, but what is needed in the filter is 10021;10897;90853;2864

Any ideas experts? I'm also open to formula suggestions as well. Thank you!

Content (required):


Version (include the version you are using, if applicable):

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!