Alteryx Designer Desktop Discussions

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

Regex

EmilioB
7 - Meteor

Hello Alteryx community,

 

I´m looking for your assistance, I have two issues with file attached:

 

1.- In "current situation sheet" I have request item #id together, so I performed a regex tokenize but I´m not able to manage to get all result separated some of them are missing. 

 

2.- Once I´m able to get partial results the file shows those results in multiple rows for the same customer number, is there any way to communize those row values in one single row?

 

I attached those files to better understanding. 

 

Thank you

4 REPLIES 4
BrandonB
Alteryx
Alteryx

Something like this? Workflow is attached.

 

parse.png

grazitti_sapna
17 - Castor

HI @EmilioB , give this a try.

grazitti_sapna_0-1602225937213.png

 

Thanks.

Sapna Gupta
EmilioB
7 - Meteor

Thank you so much!!! Sorry for my late replay on this, heavy workload last week.

EmilioB
7 - Meteor

Thank you

Labels