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

Book1.xlsx

Custom Tools

Accepted answers

clmc9601

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.

parse material information Pascal_R.yxmd

All comments

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.

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

parse material information Pascal_R.yxzp

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

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703