Using Filter Tool
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
MENDAN
5 - Atom
‎01-18-2024
07:56 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi All,
I want to be able to filter out the row that has the MAX number under LastUsPeriod column. This here is duplicate data based on level @ column but I only want to keep rows with the maximum LastUsPeriod number. How can I do this and then combine it with the rest of my data?
Labels:
- Labels:
- Best Practices
1 REPLY 1
16 - Nebula
‎01-18-2024
08:18 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Can you provide sample input and expected output?
you mentioned:
filter out the row that has the MAX number under LastUsPeriod
keep rows with the maximum LastUsPeriod number
I'm thinking "filter out" is the opposite of "keep"
You could likely use tools like Filter and Summarize and Join.
Chris
