We're excited to announce that we'll be partnering with Credly starting October 19th - see what this means and read the announcement blog here!

Alteryx Designer Discussions

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

Text file conversion error using Fixed width

vijaylnyadav
8 - Asteroid

Hi, 

 

I am using fixed width to read text file.

 

But after using same setting i am not getting proper data.

 

This is the field setting i am using.

 

vijaylnyadav_4-1624263618142.png

 

 

below is the setting.

vijaylnyadav_5-1624263756385.png

 

 

As we can see in the preview the data is not proper according to the fixed width rule.

 

Please help me on this.

 

4 REPLIES 4
Jonny
11 - Bolide

Hi @vijaylnyadav ,

can you post a workflow  as an example?

maybe if try importing the data as csv and using other tools to transform the data?

 

Cheers,

 

BR/Jonny

vijaylnyadav
8 - Asteroid

@Jonny i cant post here because of confidentiality. Here, I cant use any other file format but Text only as an input source.

ydmuley
12 - Quasar
12 - Quasar

@vijaylnyadav You can first save and export the setting from "Flat File Layout"

 

Post which you can use the same file as a reference and select:

 

"Use Field Settings from File" as a reference document.

 

Let me know if this works.

Regards,
Yugandhar Muley (Yug)

Alteryx ACE | Alteryx For Good India Lead | Bengaluru Alteryx User Group Lead
apathetichell
16 - Nebula

Can you cut and paste a text sample? I don't see anything wrong though. Your first screenshot shows where your fields are supposed to split and the red lines confirm it.

 

Your second screenshot shows your data split at those red lines. It doesn't match up with what we would see as fields - but it matches up with your first screen shot which controls where the splits occur - the field with the word "hart" in it is just left aligned instead of right aligned...

Labels