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 Not sure this is what something you are looking for ?
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.
after digging further, I have to do padleft padright on every single fields for the position to display correctly in the .txt file.