In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!
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
7 - Meteor

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
7 - Meteor

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
7 - Meteor

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})(.*)