Is there a way to output the fields with specific position?

Question

Hello,

I have the alteryx workflow build out with three sections: Header, body, Trailer.

In each section, not all fields are part of the Output, and all the fields are width length, I am using the .flat to output and the main format is .txt, however, is there a way to output at a specific position?

For example, the header section has 3 fields

Field 1 = Start position 1 end 250 and length is 250

Field 2 = Start position 251 end 272 and length is 22

Field 3 = Start position 282 end 301 and length is 20

If I want to output starting with Field 2, that mean the position is at 251 and continue on with the rest of the fields that are behind it. Is there a way to accomplish this?

Thank you!

rockeylearning · Answer

after digging further, I have to do padleft padright on every single fields for the position to display correctly in the .txt file.

rockeylearning · Answer

Unfortunately, that didn't work.

Here is an example of the expected output, in the first row is the Header section, and the fields can be blank space or with value, and if it is value it would be in the right position i.e. 330. Position is depend on the starting position of each field and the end and it width. I hope that make sense.

Sample.png

binu_acs · Answer

@rockeylearning Not sure this is what something you are looking for ?

position_051023.yxmd