CSV destination file
I would expect to see
instead I see
Is there some sort of setting I should be playing with in SC to tell it blank values are ok?
this would suggest a bug, i’d have to test it out on the latest version to verify.
in the end, you can work around it though
here I make a fixed length output file. But in your case, you’d just concatenate a big string with the comma as the separator instead.
hopefully the headers work ok – I suspect they are ok (if you need them)
I actually worked around it by outputting ~~ for each column and then doing an after step batch file that replaces ~~ with nothing. I can reproduce this also in an excel export. It seems to ignore when you have several columns of blank values coming from your source.
If you would like to submit an answer or comment, please sign in to the eOne portal.