Zip json array

Description

The Zip JSON Array activity merges multiple JSON array columns into a single array of objects. Each object in the output array contains one element from each selected input array, zipped together by index.

This is particularly useful when you have separate arrays for related data (e.g., names and values) and want to create a combined object structure for easier downstream use.

---

Input

Input Type	Format	Description
Data	Table	Should contain at least two columns with JSON arrays to zip together.

---

Output

Output Type	Format	Description
Data	Table	Original data with an added column of zipped arrays

---

Configuration Fields

Field Name	Description	Required
Column Name	A list of two or more column names that contain JSON arrays to zip.	Yes
Output Column	The name of the new column that will store the zipped array of objects.	Yes

All specified columns must contain arrays of equal or compatible lengths.
If the lengths vary, only the common range of indexes will be used to zip.

---

Sample Input

productid	productname	projectmix	salesmix
201	Laptop	[“Alpha”, “Beta”, “Gamma”]	[120, 134, 150]
202	Laptop	[“Physics”, “Beta”, “Bio”]	[120, 159, 163]
203	Laptop	[“Alpha”, “Beta”, “Gamma”]	[120, 134, 150]

---

Sample Configuration

Field	Value
Column Name	["projectmix", "salesmix"]
Output Column	Zip

---

Sample Output

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

---