Forum Discussion

mohit's avatar
mohit
New Contributor
6 years ago

Want to create a single Excel file from multiple Files

I have multiple Json files and I want to create single Excel file using Snaplogic. It should Append the data and shouldn’t overwrite the file.

3 Replies

  • cstewart's avatar
    cstewart
    Former Employee

    If you create a pipeline which reads the multiple input files, and a single output writer, that should achieve your objective. You might use the Multi-file reader Snap, or perhaps the Directory browser which gives a list of files, which you filter, and pass the names of the files to be read into the the file reader. Multiple ways to achieve it.

    • mohit's avatar
      mohit
      New Contributor

      But it will overwrite the data, I want to Append the data in a single file.

  • jcampion's avatar
    jcampion
    New Contributor III

    You may have to re-read the original file, along with the new file(s), in order to append. Several file systems don’t support append. I’m not sure if this is excel-specific, or just an append issue with your filesystem of choice.