Data360 Analyze

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

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

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

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

Josh