Zip JSON Array

Description

This activity combines multiple JSON array columns into a single JSON array object column.

Input

Data only

Output

Transformed data

Configuration Fields

• Column Name The name of the column(s) to be processed for the activity.
• Output Column Name of the new column where the output values are inserted.

Sample Input

productid	productname	projectmix	salesmix
201	Laptop	[“Alpha”, “Beta”, “Gamma”]	[120, 134, 150, 145]
201	Laptop	[“physics”, “Beta”, “Bio”]	[120, 159, 163, 195]
201	Laptop	[“Alpha”, “Beta”, “Gamma”]	[120, 134, 150, 145]

Sample Configuration

Sample Output

productid	productname	projectmix	salesmix	Zip
201	Laptop	[“Alpha”, “Beta”, “Gamma”]	[120, 134, 150, 145]	[{“projectmix”:“Alpha”,“salesmix”:120},{“projectmix”:“Beta”,“salesmix”:134},{“projectmix”:“Gamma”,“salesmix”:150}]
201	Laptop	[“Physics”, “Beta”, “Bio”]	[120, 159, 163, 195]	[{“projectmix”:“Physics”,“salesmix”:120},{“projectmix”:“Beta”,“salesmix”:59},{“projectmix”:“Bio”,“salesmix”:163}]
201	Laptop	[“Alpha”, “Beta”, “Gamma”]	[120, 134, 150, 145]	[{“projectmix”:“Alpha”,“salesmix”:120},{“projectmix”:“Beta”,“salesmix”:134},{“projectmix”:“Gamma”,“salesmix”:150}]