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.
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.
But it will overwrite the data, I want to Append the data in a single file.
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.