Welcome & Introductions

Get to know the people behind the avatar! Introduce yourself, welcome peers, build connections & extend your network.

Take a moment to introduce yourself to the Community. We'd love to get to know you!

Learn More

want to select data form a concatenated field in Alteryx

sahasanb
7 - Meteor

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

Output : 28

 

Column Value : aaa (55%)

Output : 55

3 REPLIES 3
chrissgtan
7 - Meteor

@sahasanb Please try the attached yxmd file.

Thanks,
Chris

sahasanb
7 - Meteor

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

 

sahasanb
7 - Meteor

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

Labels