Want to create a single Excel file from multiple Files

[mohit]

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.

[cstewart]

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]

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

[jcampion]

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.