09-12-2019 12:31 PM
Pipeline shows accurate output after Script snap. However when we the output is loaded in lets say CSV file, it loads any random data
09-12-2019 01:32 PM
What are your settings on the CSV Formatter and File Writer?
09-13-2019 04:36 AM
09-13-2019 07:56 AM
Those Binary Header settings on the CSV Formatter seem strange. The snap is going to create one binary CSV document containing the ALL of the documents from the script output. So you can’t really set headers containing detail-level values. The binary header is more for stuff like content-type, content-location, etc. Doesn’t explain why it’s creating the output you observed, but might be worth just taking those out and seeing if it makes any difference.
09-13-2019 12:24 PM
Thanks for the response. So our requirement was not write the data in CSV file, but in Database. But because the Pipeline was loading strange data in DB, we just loaded the data into a file to showcase the issue.