Alteryx Logic Request

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.

Datasets

Designer Cloud

Accepted answers

flying008

Hi,@Jaganmohan

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

录制_2022_12_13_11_43_11_137.gif

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.

PanPP

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.

Sample WF - Results Column Final.yxmd

All comments

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.

Sample WF - Results Column.yxmd

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.

binu_acs

@Jaganmohan One way of doing this dynamically

Transpose_1212.yxmd

flying008

Hi,@Jaganmohan

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

录制_2022_12_13_11_43_11_137.gif

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

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.

Sample WF - Results Column Final.yxmd

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703