Output all fields including empty field in .txt

[rockeylearning]

hello Community,

I have multiple Unions, and I've set the properties to Ignore - Continue Processing Records and Output All Fields option, my Output file format is .txt with \0 delimiters. But when it output, it doesn't include the empty fields, how can I get it to include it?

Edit: these are all fixed length fields

Thank you

[SPetrie · Accepted solution]

Use .flat as your file format. You can still give the file name the .txt extension and it will create two files, one .txt and and one .flat

I use that for my fixed width files and have no issues. Usually end up just deleting the .flat and keeping the .txt

If that doesnt work, we may need to see an example input with expected output to try to troubleshoot further.

[rockeylearning]

hi @SPetrie I tried the flat you mentioned, it looks to be working. I've never saved as .flat before, and if I am reading it right, it creating two files one is .flat and the other is .asc. and the Asc. is what I need to change it to .txt afterward. But is there a way to automatically have it .txt without having to do another workflow to rename the file?

[SPetrie]

You can setup the output file name to be whatever you want really.

You can specify the specific file name you want in the output tool, or use an additional field to change the file name.

In this screenshot example, I would end up with a test.txt and test.flat file for the output

[rockeylearning]

thank you