Alteryx Designer Desktop Discussions

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

Separate / Combine words in a String and put them on a new row.

calvincarr29
8 - Asteroid

I need this:

Screenshot 2024-09-05 131501.png

To look like this:

Screenshot 2024-09-05 131544.png

1 REPLY 1
TUSHAR050392
10 - Fireball

Hey @calvincarr29 

 

I see the data that you want to separate has % as the common delimiter. You can use text to column and % as delimiter and keep number of column - 2. This will be generate the two new columns with 50 values and you can name them as Value3 and Value4

Then you need to do some manipulation of existing data using a formula tool. For Value2 column you will write IF ISNULL(Value4) THEN Value2 ELSE Null() ENDIF and same for Value3 column

 

Hope this helps.

Labels