Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Split Row in 2 Rows

cutehappybear
7 - Meteor

Hello,

 

I have a table that goes like this.

 

IDFieldValue
123Temperature3,0-23,0
456Temperature1,0-20,0
789Temperature2,0-21,0
012Temperature

1,5-25,5

 

But I want to separate the values using the hyphen and create something like this:

 

IDFieldValue
123Temperature_Min3,0
123Temperature_Max23,0
456Temperature_Min1,0
456Temperature_Max

20,0

 

I have seen the Text to Column function, I can separate them into rows but I can't change the name of the Fields.

Any suggestion?

5 REPLIES 5
atcodedog05
22 - Nova
22 - Nova

Hi @cutehappybear 

 

Edit: updated workflow

 

Here is how you can do it. Use text to column tool like highlighted below and multi-row formula tool.


Workflow:

atcodedog05_1-1641895918746.png

 

Hope this helps : )

 

binuacs
20 - Arcturus

@cutehappybear Another option

 

binuacs_0-1641895952810.png

 

Christina_H
14 - Magnetar

Here's a similar approach that also renames the fields:

Christina_H_0-1641895967393.png

 

RolandSchubert
16 - Nebula
16 - Nebula

Hi @cutehappybear ,

 

I'd like to add another approach - using Text To Columns to split the value field and the Arrange tool to organize the result in rows could also be a solution.

 

In the Arrange tool, you can select a key field (ID) and add columns (only one with values)/ descriptor columns.

You add a column and assign both fields (value1 and value2, the result of the Text To Columns split) to that column as "rows".

You can fill the "Descriptor Column" manually for the resulting rows.

 

2022-01-11_14-23-06.jpg

 

 

Hope this is helpful.

 

Best,

 

Roland

atcodedog05
22 - Nova
22 - Nova

Happy to help : ) @cutehappybear 

Cheers and have a nice day!

Labels