cancel
Showing results for 
Search instead for 
Did you mean: 

Flatten JSON files into CSV files

schelluri
Employee
Employee

Created by @schelluri


The pipeline pattern flattens a JSON file, which has multiple objects, and turns it into a CSV file.

Flattendata%20-%20Satya%20Chelluri

Configuration

Sources: JSON Generator
Targets: CSV file
Snaps used: JSON Generator, JSON Formatter, JSON Parser, Script, CSV Formatter, File Writer

Downloads

MS_Flatten_Script.slp (31.4 KB)

2 REPLIES 2

walkerline117
Contributor

I don’t understand the behavior of CSV formatter snap here.

So normally, for snaps like file writer snap: it is one in one out: one document in, then one file out.

Why the CSV formatter snap does multiple documents in, only one document output out?

gg433
New Contributor III

This worked for me.  Thank you!  Always running into flattened file issue when trying to save as csv after using Group snap to deduplicate records.