Write Data List to Text File
Comments
-
Hello,
I am wanting to write a couple hundred thousand records from a Decisions data type to a text file. I know I can loop through and write each line one at a time, but is there a way to insert the records in bulk at once?
Thank you. -
Found an answer for you.
Create a Report of the Decisions Data Type Use a “Run Report” step Set Properties > Output Settings > Return Data Option = “CSV File” This CSV can be read by any txt reader, or, if you, specifically, want a .txt file Use a “Create File” stepi. Map the RunReportResults.Contents to the Inputs > Data > Path field
ii. Set the Inputs > File Name to “{path}.txt” (eg. C:program files est.txt)
This method automatically creates a line break between Rows/Objects when read by a text reader.
Let me know if this gets you what you need.