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

separation of commas inputs

Pascal_R
8 - Asteroid

Hi Cummunity Team,

 

Do you see any solution in Alteryx where I can filter out the numbers/Date?

Below is an entry from user where they comment on orders.

As an example:

R 1, B 2, F 03.07.2021

 

I try now to get now each number into a separate column.

 

R= Release 1, 

B= Backorder 2

F= Future date to 03.07.2021 (that will apply to the 2 on backorder

 

In addition, I added in attached the configurations which are possible...

Hope someone can show me a way to do that the best way.

 

Thank you very much in advance,

 

Pascal

3 REPLIES 3
clmc9601
13 - Pulsar
13 - Pulsar

Hi @Pascal_R,

 

I'm not sure this is exactly what you are looking for, but hopefully it helps in some way! I used regex to parse the release, backorder, and future date information into separate columns.

 

Screen Shot 2021-05-03 at 11.02.14 AM.png 

Pascal_R
8 - Asteroid

@clmc9601 

 

Thank you very much for providing me that solution. 

This is really what I was looking for. Would it be possible to provide me the workflow in a different version?

I use Alteryx version 2019.4.

 

Best regards,

Pascal

clmc9601
13 - Pulsar
13 - Pulsar

Hi @Pascal_R ,

 

Sure, no problem. I'm pretty sure Alteryx will let you open files from a newer version now. It'll give you a warning, but you just have to agree. Here's the adjusted yxmd file.

Labels