Free Trial

Alteryx Designer Cloud Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Cloud.

NEED URGENT HELP Separating 1 column into multiple column.

Sivory18
5 - Atom

Hi guys, I need to go from Table A > Table B. Pleaee help

5 REPLIES 5
KGT
12 - Quasar

I don't normally like suggesting REGEX straight up, but it's the easiest way.

 

REGEX TOOL: Parse

(.{5})(.{5})(.{3})(.{9})(.{5})(.{6})(.{5})(.{5})(.{3})(.*)

 

This will create a field of the length specified for each group.

Sivory18
5 - Atom

Hi KGT, the values come out as null. Is there a way to fix that

alexnajm
18 - Pollux
18 - Pollux

Can you show us @Sivory18 ? That statement looks accurate!

Sivory18
5 - Atom

Here the document if you want to try @alexnajm. 

KGT
12 - Quasar

I didn't look at the field and as there was no data had to recreate something small. I looked at the created fields not the original field where it actually comes from 2 different fields and so that previous formula would have worked if F3 and F4 were concatenated.

 

  • First Parse: ON F3: 
    • (.{5})(.{5})(.{3})(.{9})(.{5})(.{6})(.*)
  • Second Parse: ON F4: 
    • (.{5})(.{5})(.{3})(.*)