Writing flat file

Question

Hi Team
For my current use case, I need to write a flat-file.

I am using the following pipeline to write csv.

Input to JSON formatter is a document of arrays each having different no of properties.

Can you please suggest a way to generate CSV file ignoring all null values and writing only what is present?
Note -  Each input document to CSV formatter has different set of properties.
Thanks in advance

del · Answer

@ayush.vipul, see if the attached pipeline will assist you as an example.  I have simple, arbitrary data in the JSON Generator, but the Mapper and Fixed Width Formatter is the key.  The Field Width value in the Formatter is also arbitrary, but needs to be set large enough to handle the longest expected line widths.
Community.5728_2019_07_19.slp (5.8 KB)

ayush_vipul · Answer

@del Thanks.
This helps us achieve what we we looking for.
Best Regards
Ayush

sshaik · Answer

After trying this scenario. I want read that file and send the data to AWS.But, I’m getting same thing again in the Fixed width Parser

sshaik · Answer

sshaik · Answer

@del Could you please help on this issue.

Forum Discussion

Writing flat file

5 Replies

Recent Discussions

Google Sheets Subscribe questions

Basic string transformations not working

Can we generate XML file in pretty print format using native snapLogic snaps?

Multipart Reader failure - 'content-type' was not found

Unable to write sldb file to file system