Good afternoon,
Very new and still learning Alteryx.
Here is the data I have. I have 4 columns pulling data from different places. I want to end up with the "Result" Essentially merge any uniques into one. And in the last row note it kept both values but still merged the unique values into one. There is a lot of other data after these fields.
All 4 NODE ID's could be empty or could be 4 unique values.
I tried some complicated If then statements and gave up. I couldn't get Summarize to work as mentioned HERE
This is also what I'm looking to do. This was a feature request. Concatenate Unique
Running Alteryx Designer 2023.1.1.123
| NODE ID | NODE ID 2 | NODE ID 3 | NODE ID 4 | RESULT |
| 123ABC | 123ABC | 123ABC | 123ABC | 123ABC |
| 789CDE | | 789CDE | | 789CDE |
| | | | 789CDE | 789CDE |
| ABC123 | ABC123 | ABC123 | ABC123 | ABC123 |
| HIK678 | L9999L | HIK678 | HIK678 | HIK678 ; L9999L |
