Output Empty File
I have a question in case someone in the community has a solution. Using Data360 to prepare files for a separate loading process. That process requires all five (5) files to be present -- even if some of the files have no data and just a header row. In fact, it will fail if there is just one (1) row of fake data.
I can't find a way for Data360 to output a file with no data. Has anyone encountered this and found a solution? If so, please share.
Thanks,
Josh
-
Hi Josh, like you I can't seem to get the CSV node to write out a file when it has 0 records. We're looking into it.
In the meantime I believe the data flow here will get you where you need to be. If the records are 0 it will write out a raw file with the field names with a delimiter you can specify on the composite, It will default to pipe as I see on your other post you mention that's what you are using. Otherwise it will just write out a regular CSV file. The FileName value is set at the composite level.
Attached files
Please sign in to leave a comment.
Comments
2 comments