Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer and Intelligence Suite.
SOLVED

How do I select a group of data based on a column with multiple segments of information

nhanney
5 - Atom

I receive a report that breaks down accounts weekly balances but rolls the data so the sheet contains historical data as well. How do I systematically select the block of most recent data? Below is an example of the structure I am working with and I would only want to work with the 9/22/22 data in this case.

 

9/1/2022   
NameCategoryIDValue
Johna110
Nickb220
Adamc315
Steved43
    
9/8/2022   
NameCategoryIDValue
Johna18
Nickb214
Adamc398
Steved422
    
9/15/2022   
NameCategoryIDValue
Johna146
Nickb284
Adamc337
Steved498
Waltc51
    
9/22/2022   
NameCategoryIDValue
Johna141
Nickb275
Adamc334
Steved482
Waltc564
3 REPLIES 3
RogerS
Alteryx
Alteryx

The attach workflow shows how you can accomplish this.  If you have an older version of Alteryx you can open it in notepad to change the version if needed.

gautiergodard
12 - Quasar

Hello @nhanney 

You could do something like the attached! 

Please like and mark this post as resolved if it provided the answer to your question.

 

Hope this helps!

CarliE
Alteryx
Alteryx

@nhanney 

 

Rogers workflow does exactly what you needed. To get the max date automatically, instead of using the filter he put in there, use a summarize to get the max date and join back to the data set

 

CarliE_0-1665517198612.png

CarliE_1-1665517214961.png

 

Please let us know if you have any questions!

 

Carli
Labels