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

Text to Column

MarkPitcock
7 - Meteor

Afternoon All, 

 

I have a set of data with multiple columns. 2 columns I need to split into rows has a pipe | delimiter. I need to retain the same data in the rows created from the text to column tool. Using the text to column tool on column B works well but when applying the second time on column E this is when I run into problems. 

 

Below is the input / output that I am trying to achieve 

 

Any help will be appreciated. 

 

Example 1    
Input    
ABCDE
1A|BStartEnd100|101
Output    
1AStartEnd100
1BStartEnd101
     
Example 2    
Input    
1A|B|CStartEnd100|101|102
Output    
1AStartEnd100
1BStartEnd101
1CStartEnd102

 

2 REPLIES 2
atcodedog05
22 - Nova
22 - Nova

Hi @MarkPitcock 

 

Here is how you do it.

atcodedog05_0-1621879164959.png

1. Use record id tool to set unique key for rows.

2. Using text to column, delimiter as |, and split to rows.

3. Using multi-row formula tool, groupby RecordID, generating group ID. Group id is the position which will be used for mapping.

4. Joining Field 2 & Field 5 on record ID & group ID. This way it matches to row & position.

 

Hope this helps 🙂

 

MarkPitcock
7 - Meteor

atcodedog05 - thank you so much , you've solved the problem.

Labels