Alteryx Designer Discussions

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

PLEASE HELP - Assign a Flag to a maximum date in a month.

tarunIMDG
7 - Meteor

I am trying to create a field "EOM Flags" that tags the maximum date as 1 in a month for which the payments were made.  For ex - if there are 3 payment dates in a period then tag 1 to maximum date and tag 0 to the other dates (see screenshot attached).

 

tarunIMDG_0-1650410603570.png

 

2 REPLIES 2
WSDATA
7 - Meteor

See if this helps.  

 

The upfront parts are not needed, just creating a data set that looked something like yours.

 

The Summarize groups by "Period" and finds max of the Payment data.  It will return the latest date for each month.

 

Join that back to the original data set and union the items that did not match.  

 

Finally clean up the nulls with a formula.

 

Hope it helps!

flying008
11 - Bolide

@tarunIMDG 

Dear, pls see that. 

Maybe you need sort by [Pay Date] first to process.

录制_2022_04_20_08_54_19_31.gif

Labels