Filter by Max Date in Formulae Tool
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi Guys,
I have a column of dates in Alteryx - Using the formulae tool I want to create a new column with the MAX date from the column of dates
Regards,
Tommy
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I'd like to add to @atcodedog05 and suggest that you want to use the APPEND FIELDS tool to add the max date value(s) onto the original records.
cheers,
mark
Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi - i dont want to break up my data and rejoin it then - Is there a way to do this using a formuale tool to create a new column and insert the max date out of all the months
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Nope thats not possible. You need to find max using summarize and use append tool to add it back.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
This is great - I have never used the Append tool before - thanks for this again
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Happy to help 🙂 @Tommy_Alterax
Cheers and Happy Analyzing 😀
Feel free to reach out if you face any issues 🙂
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Could you help me figure best way to filter this dataset to max date and second max date (closest one to max date but not equal to or greater than it).
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
sumarise tool - to get your record list
sort - to order them
sample - to take just the top / newest 2
sample tool again if you want to split the 1st and second oldest
seems convoluted but think this is the easiest way