Selecting from a range of correct values

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 -

Data Investigation

Accepted answers

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 : )

All comments

Hi @Abhii2658 ,

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

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 : )

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

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15866

MarqueeCrew 13708

apathetichell 13703