SOLVED
Filter certain rows
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Kallis
8 - Asteroid
07-24-2024
04:48 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi
I have a requirement based on which I need to remove certain rows from the final output. From the below table, I need to leave out all those cost elements that starts with 5 and pick the ones that starts with 6.
I do not know whether this can be achieved using the Filter Tool. Kindly help
Cost Element | Posting Date | Test 1 |
520323 | 24-06-2024 | Test |
520323 | 24-06-2024 | test |
520323 | 24-06-2024 | Test |
520323 | 24-06-2024 | Test |
520323 | 24-06-2024 | Test |
520323 | 24-06-2024 | Test |
520323 | 24-06-2024 | Test |
520323 | 24-06-2024 | Test |
602024 | 12-06-2024 | t |
602024 | 12-06-2024 | t |
602024 | 28-06-2024 | t |
602024 | 28-06-2024 | t |
602024 | 12-06-2024 | |
602024 | 28-06-2024 |
Solved! Go to Solution.
Labels:
5 REPLIES 5
18 - Pollux
07-24-2024
04:56 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
A StartsWith function in a filter tool should work well for your use case
18 - Pollux
07-24-2024
04:56 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
StartsWith([Cost Element], “6”)
07-24-2024
04:58 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@alexnajm I thought about such a parameter but it is not there
07-24-2024
05:17 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Sorry @alexnajm
You meant a function. I just saw that
07-24-2024
05:43 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks @alexnajm
It works. I will mark this as solution
