hkaplan
7 years agoFormer Employee
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)