Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
community Alteryx IO Mission Control
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Free Trial

Alteryx Designer Desktop Discussions

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

Text to column on Multiple Data

Devika
8 - Asteroid
‎03-10-2022 06:06 AM

Hello,

 

On the below table I only wanted to create another column name 'ADML' which would only contain data starting with D not the no's in the bracket.

Please help me with the formula which would filter out the no's in bracket.

 

Trade Refs (Ours)     ADML 
D345447 (000005) 
D343792 (000005) 
D527015 (002884) 
D520288 (002884) 
D520288 (002884) 
I129702 (000005) 
I129702 (000005) 
D418531 (000005), D420345
(000005)		 
D428163 (000005), D428920
(000005)		 
D402199 (083004), D523515
(083004), D317365 (083004),
D325464 (083004), D419502
(000005), D525641 (000005)		 
Labels:
Reply

Accepted SolutionSolved! Go to Solution.

8 REPLIES 8
binuacs
21 - Polaris
‎03-10-2022 06:17 AM

@Devika 

binuacs_0-1646921817029.png

 

RegEx11.yxmd
Reply
Luke_C
17 - Castor
17 - Castor
‎03-10-2022 06:19 AM

Hi @Devika 

 

Here's my approach:

 

  1. Record ID to help group the data downstream
  2. Split data to rows
  3. Check if it starts with 'D' (a few start with I which you don't want based on your requirements) and populate ADML
  4. Group records back together

 

Luke_C_0-1646921918853.png

 

New Workflow1.yxmd
Reply
EN6924
10 - Fireball
‎03-12-2022 12:06 AM

Assuming your dataset has 10 records as mentioned above, My solution -

 

EN6924_0-1647072314427.png

 

ADML.yxmd
Reply
Devika
8 - Asteroid
‎03-16-2022 02:28 AM

this is the output dat im willing to get 

 

Trade Refs (Ours)     ADML 
D345447 (000005)D345447
D343792 (000005)D343792
D527015 (002884)D527015
D520288 (002884)D520288
D520288 (002884)D520288
I129702 (000005)I129702
I129702 (000005)I129702
D418531 (000005), D420345D418531,D420345
D428163 (000005), D428920D428163,D428920
D402199 (083004), D523515D402199,D523515,D317365,D325464,D419502,D525641
(083004), D317365 (083004),
D325464 (083004), D419502
(000005), D525641 (000005)
Reply
0 Likes
binuacs
21 - Polaris
‎03-16-2022 02:50 AM

@Devika any specific condition which has to consider when concatenate the rows, I can see the last 4 rows you concatenated in your output result.

Reply
0 Likes
Devika
8 - Asteroid
‎03-16-2022 03:03 AM

Hello@binuacs,

 

Just modified the expected output 

 

Trade Refs (Ours)     ADML 
D345447 (000005)D345447
D343792 (000005)D343792
D527015 (002884)D527015
D520288 (002884)D520288
D520288 (002884)D520288
I129702 (000005)I129702
I129702 (000005)I129702
D418531 (000005), D420345D418531,D420345
D428163 (000005), D428920D428163,D428920
D402199 (083004), D523515(083004), D317365 (083004),D325464 (083004), D419502(000005), D525641 (000005)D402199,D523515,D317365,D325464,D419502,D525641
Reply
0 Likes
EN6924
10 - Fireball
‎03-16-2022 07:27 AM

I did it like the following way, got accurate result as requested -

 

EN6924_0-1647440773994.png

 

Please correct me if this can be done in more short way.

 

Test5.yxmd
Reply
binuacs
21 - Polaris
‎03-16-2022 07:43 AM

@Devika 

binuacs_0-1647441792066.png

 

RegEx11.yxmd
Reply
view community events calendar
designer new user guide
Labels