Alteryx Logic Request

[Jaganmohan]

Hi Team - Need your support on below, Thanks in advance.

I need to generate result Column as a output (shown below).

Result Logic : In case last 3 days numbers are same then A  or if not then  B.

My challenge was dates (Column headings)  are keep changing because i am extracting last 3 days of information  and at the same time i need a final output with dates similar like below mentioned. 

ID	12/7/2022	12/8/2022	12/11/2022	Results
631	3.66	3.64	3.6	B
28206	150	150	150	A
28208	31	31.9	32.21	B
34638	21.41	21.41	21.41	A
36982	45.89	45.8	44.6	B
47349	13	13	13	A
49887	29.11	28.91	29.35	B
51031	30.38	31.26	31.15	B
61909	274	274	274	A

Thanks.

[ellen-wiegand]

Are your columns always in the same order? You could skip field names in the input tool, and/or use a dynamic rename tool

[PanPP]

Hi @Jaganmohan 

When you bring in the data, how does the preview look like for the first couple of rows? Are the dates in row 1 or row 2? You can set some logic where if it's null or empty, you can set the value to Date 1/Date 2/Date 3 and then use a dynamic rename tool to bring those values as column headers.

Attached is a sample WF that gets your output after taking making sure the column names can be scalable. 

Hope this helps.

[Jaganmohan]

Thanks - I am good with formula tool and generating Results out of that.

But, my challenge was those dates (Column headings) are keep on changing  and at the same time i need a solution with Result Column  with Dates as i mentioned in the table.

Notes : Dates are not constant....always i used to extract last 3 days info.    

[Jaganmohan]

Thanks.

But, my challenge was those dates (Column headings) are keep on changing  and at the same time i need a solution with Result Column  with Dates as i mentioned in the table.

Notes :  1) Dates are not constant....always i used to extract last 3 days info.   2) Need a final output with  Dates + Result Columns.

[binuacs]

@Jaganmohan One way of doing this dynamically 

[flying008 · Accepted solution]

Hi,@Jaganmohan 

There is a easy way for dynamic calculate your  values of date-name fields.

BTW, the workfolow key point is formula to match all same values by use REGEX_Match()

Spoiler

IIF(REGEX_Match([Concat_Value], "^([^|]+?)\|\1\|\1$"), "A", "B")

******

If it can help you , please mark it as a solution and give a like for more share.

[Jaganmohan]

Hi - Thanks for the solution.

Could you please provide me the Workflow Solution if possible.

[flying008]

Hi, @Jaganmohan 

Sorry, I can't upload the wf because the security police, but the process are so clear, so you can flow it to get output. 

[PanPP · Accepted solution]

Hi @Jaganmohan 

I have uploaded a sample WF that @flying008 has shown in his image.

Hope this helps. Please like the post and mark both of our posts as solutions if it does.