Let's Reconnect, thank you for making 2022 our best year yet.

Look Back
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
11
Views
2
Comments
in Reporting and Analytics for HCM 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):

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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