Output Empty File

Follow

Joshua Campbell

• July 30, 2020 22:36

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

0

• 

  Gerry Mullin

  • July 31, 2020 19:25

  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

  Write Out Blank CSV.lna

   

  1

  Comment actions Permalink
• 

  Joshua Campbell

  • August 01, 2020 00:09

  Hey Gerry, thanks again. This worked like a charm. I added a small flow after to rename for my project. 

  Josh

  0

  Comment actions Permalink

Please sign in to leave a comment.