Convert Excel Columns to JSON Arrays

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.

Configuration

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:

Downloads

Convert Excel Columns to Arrays.slp (12.6 KB)
ExcelColumnToArray.xlsx (8.7 KB)