Contributed by @hkaplan
This pipeline reads in an Excel file with multiple columns, 1 to n number of rows with null cells and converts each Excel column into a JSON array with all of the null rows removed.
The trick here is SnapLogic’s Aggregator Snap’s Concat function.
Source: Excel spreadsheet Columnar data
Target: Excel columnar data as an array
Snaps used: File Reader, Excel Parser, Aggregate, Mapper,
The sample Excel file looks like this:
The resulting array looks like this: