Output all fields including empty field in .txt

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

Output

Accepted answers

SPetrie

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.

All comments

SPetrie

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

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703