separation of commas inputs

[Pascal_R]

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

[clmc9601]

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.

 

[Pascal_R]

@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 · Accepted solution]

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.