Regex multi-field formula

I have 5 columns in a file where certain columns have multiple fields concatenated. I want to segregate the fields with a , into two different fields.

Attached a sample screenshot. I understand i have to use multi-field formula. But not sure of what to write in expression.

Underlined columns in focus

Please suggest.

Thanks,

Anudeep

Alteryx Test.PNG

Regex

Transformation

Accepted answers

CoG

I can modify the workflow some as needed based on some intuitions I have, but I wanted to get your feedback first. Here is a workflow that uses the Multi-Field Formula Tool (which really only works because you only want 2 columns).

Transpose Tool would be the more appropriate tool in general for a problem like this followed by Text To Columns Tool (set to output to rows).

Sample Workflow.yxmd

grazitti_sapna

Hi @Anudeep_Yalamuru
Another way of doing this.
If it works for for you. Kindly accept it as Solution.
Thanks

MultiField Wf.yxzp

All comments

CoG

Transpose Tool would be the more appropriate tool in general for a problem like this followed by Text To Columns Tool (set to output to rows).

Sample Workflow.yxmd

Anudeep_Yalamuru

Thanks Andrew. This is good enough. Yes i have few more transposes and fixes to be done after this. I needed only two columns as I will have only 2 fields attached.

Regards,

Anudeep

Anudeep_Yalamuru

Just a question on why two multi-fields Andrew? @CoG

CoG

Multi-Field Tools cannot create new a column and update a column at the same time. The first Multi-Field Tool captures the second part after a ",", then second Multi-Field Tool goes back through the data to get rid of the second part that was just extracted.

flying008

Hi, @Anudeep_Yalamuru

If you need split to n columns by dot:

录制_2024_01_06_13_15_17_445.gif

grazitti_sapna

Hi @Anudeep_Yalamuru
Another way of doing this.
If it works for for you. Kindly accept it as Solution.
Thanks

MultiField Wf.yxzp

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703