Writing flat file
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-18-2019 10:23 AM
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-19-2019 12:04 PM
@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)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-13-2019 07:23 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-08-2023 10:27 PM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-08-2023 10:28 PM
