Selecting from a range of correct values

[Abhii2658]

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          -

[Jean-Balteryx]

Hi @Abhii2658 ,

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

[atcodedog05 · Accepted solution]

Hi @Abhii2658 

Here is how you can do it.

Workflow:

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]

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