Write Data List to Text File

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” step 
    

    i. 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.

Sign In or Register to comment.