How to make this formula dynamic

[wonka1234]

Hi,

I have the formula:

Max_DIAMOND_Date:

if [c_Action_Date] <= [File_date_with_days2] then [202210]
elseif [c_Action_Date] <= [File_date_with_days2]
then [202211]
else "" endif

The months can shift based on my inpuits to my dataset.

Does any one have any idea on how to make this dyanmic? What is the months were just 202210? what if my columns were 202211 202212? All these are possibilities.

[wonka1234]

@RobertOdera 

It is after a transformation actually! i did a transpose on 202210 and 202211.

N_VALUE	c_Action_Date	File_date_with_days	202210	202211
jon	6/27/2022	11/13/2022		Y
joey	6/27/2022	11/13/2022		Y
kim	6/27/2022	10/13/2022	Y
lou	6/27/2022	11/13/2022		Y
ren	6/27/2022	10/13/2022	Y
bob	6/27/2022	11/13/2022		Y
andrew	6/27/2022	11/13/2022		Y
joe	6/27/2022	10/13/2022	Y
don	6/27/2022	10/13/2022	Y
rudy	6/27/2022	10/13/2022	Y
bobby	6/27/2022	10/13/2022	Y
drew	6/27/2022	10/13/2022	Y
carlos	6/27/2022	10/13/2022	Y
pete	6/27/2022	11/13/2022		Y
jamie	6/27/2022	10/13/2022	Y
justin	6/27/2022	11/13/2022		Y
rich	6/27/2022	11/13/2022		Y
rob	6/27/2022	10/13/2022	Y
trevor	6/27/2022	11/13/2022		Y
adam	6/27/2022	11/13/2022		Y

here is the sample dataset before transformations.

Sadly i am worried it wont be dynamic for alteryx server use.

[RobertOdera]

Hi, @wonka1234 

Here you go.

Kindly mark it as an acceptable solution if it works for you.

Cheers!