Empty CSV File With Header Row
I have a need to write an “empty” CSV file that includes only the header row information in the case that there’s no data to populate the file. Does anyone know a good way to do this? Anything to do ...
Forum Discussion
rustin - the SLDB (file space in your SnapLogic project folder) has a limit of 100MB. The path specified by pipe.tmpDir is limited by the amount of temp space allocated to SnapLogic on the execution node, so you would need to check with your server admins in your environment.
However, Excel itself has a maximum record count of 1,048,576 rows and 16,384 columns per sheet. If you need more than that, would CSV be sufficient? The file size would be significantly more as a CSV since Excel compresses the data, but it may be worth trying.
Also note that pipe.tmpDir is transient and exists only during pipeline execution, so as soon as the pipeline completes, everything in that directory is purged.
Hope this helps!
Can you share a screenshot of your pipeline that handle this? from the router.
I am in the same situation. I need to write an empty with header CSV file if there is no input data.
ThanksI was just looking at this oddly enough. It is a simple POC I built for another team. The issue was that, sometimes, the object was not updated in Salesforce since the last run and returned null. So, uncheck “Ignore Empty Result” in the Salesforce Read, make sure the Mapper is Null Safe, and have the Router look for your key value. If it finds it, carry on as normal. If it does not, parse the object keys and write with the constant as I posted prior.
Mine looks a bit different. I left outer join my input stream with my static header row and evaluate for the presence of data in my router. Then I either remove the unnecessary header data element or map the header row data to the variable name expected downstream for the data, and union back together.
I have a lot of stuff going on downstream to also add a single column “end of file” footer row, which was also a real pain in the butt.
