Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Free Trial

Alteryx Designer Desktop Discussions

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

Selecting from a range of correct values

Abhii2658
8 - Asteroid

Good Day Everyone 

 

I have a sample data such as 

 

PO#          Setting

1234          0

1234          0

1234          0

1234          0

1234          0

1234          ABCD

1234          ABCD

1234          ABCD

1234          ABCD

1234          ABCD

1234          ABCD

 

I am using a join tool match the PO# against a set of values to extract the settings. Now i need for format the end result in this format 

 

PO#          Setting

1234          ABCD

1234          -

1234          -

1234          -

1234          -

1234          -

1234          -

1234          -

1234          -

1234          -

1234          -

3 REPLIES 3
Jean-Balteryx
16 - Nebula
16 - Nebula

Hi @Abhii2658 ,

 

Can you share sample data files please ? And explain how you obtain your output ?

atcodedog05
22 - Nova
22 - Nova

Hi @Abhii2658 

 

Here is how you can do it.

 

Workflow:

atcodedog05_0-1628084286486.png

 

1. Using filter to keep non 0'a

2. Using summarize to get a single entry of setting for each PO#

3. Using join tool to join back on PO#

4. Using multi-row formula to keep only first entry.

 

Hope this helps : )

Abhii2658
8 - Asteroid

How would write this statement from excel in Alteryx 

=IF(AND(LEN(A1)>0,LEN(B1)>0),(IF(ANS=(A1&" "&B1),"Exact Match", "Non Match")),"No Trigger")

 

Thanks 

Labels
Top Solution Authors