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)
Aggregate Snap example
This is an example to illustrate the Aggregate Snap with Functions like Sum, Count, Min, Max and Average. The 1st Snap generates the required input data like Name, Age, Dept, etc. The next Snap “Aggregate” is configured with functions like Sum of Age for Total Age Count of Name (Unique column) for Total employee Min of Age for Minimum Age Max of Age for Maxiumum Age Avg of Age for Average Age Below is the quick screen shot of the configuration of the functions of this Snap. Attached is the .slp for the pipeline reference of this example.Aggregate_2017_03_11.slp (6.0 KB)
