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.
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.