We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
community Alteryx IO MyAlteryx
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
Start Free Trial

Alteryx Designer Desktop Discussions

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

want to select data form a concatenated field in Alteryx

sahasanb
7 - Meteor
‎07-02-2022 03:51 PM

Column Value : SSSS Design # 1 1 of X (28%)

Output : 28

 

Column Value : aaa (55%)

Output : 55

Labels:
Reply
0 Likes
3 REPLIES 3
chrissgtan
7 - Meteor
‎07-03-2022 08:29 AM

@sahasanb Please try the attached yxmd file.

Thanks,
Chris

select data from a concatenated field.yxmd
Reply
0 Likes
sahasanb
7 - Meteor
‎07-03-2022 12:30 PM

Input : Oxxxxxxx
Design #1 - 1 of x
10%
OutPut 10

Input :
Sxxxxx
Design # 1
1 of X
(28%)

OutPut 28

Input : Sxxxx 50mg
Output 0

Input Simc 50

 

Reply
0 Likes
sahasanb
7 - Meteor
‎07-03-2022 12:31 PM

No man its not working as

 

Input : Oxxxxxxx
Design #1 - 1 of x
10%
OutPut 10

Input :
Sxxxxx
Design # 1
1 of X
(28%)

OutPut 28

Input : Sxxxx 50mg
Output 0

Input Simc 50

Reply
0 Likes
Live Office Hours
Labels
Top Solution Authors
View All