Text to coloumns

Jaganmohan

Hi,

I need to separate the fields using Text to column tool (\s) - but I am unable to fit the data under exact field names.

If there is no data under the field still its showing right side column data instead showing blank.

Need exact format like - if we use excel fixed width functionality(alt+d+e+f).

Please Help me on this - Thanks.

Jag123.csv

Common Use Cases

Accepted answers

DannyS

Hi @Jaganmohan ,

the key to this issue is reading in the file to Alteryx properly. My recommendation would be to save the Jag123 Input as a text file (attached), and then read it into Alteryx as a fixed width text file:

From there, you can define the column widths for each column in your text file:

This will do all the hard parsing work for you! And then just use a couple simple prep tools to get to your desired output. I went ahead and attached a workflow that should get you to your solution with these above steps. Please confirm if this solution is useful!

Best,

Danny

Jag123_workflow.yxmd

Jag123.txt

All comments

mbarone

Is the CSV the "before" look, or the "after" look? Let us know what the input is, and what you'd expect the output to be.

Jaganmohan

Thanks for the quick response - I am attaching the excel file which consist 2 sheets (Input & required output).(Please focus on blanks-Those are not adjusting under correct field names).

Please help me on this issue.

Jag123.xlsx

Quick Links

This months top contributors

FláviaB 262

caltang 177

DanM 167

IraWatt 157

gawa 157