Skip to main content
All CollectionsTemplatesBasic
Merge JSON data using JQ based on a common Key/Value - Workflow Template
Merge JSON data using JQ based on a common Key/Value - Workflow Template

Simple example using JQ to merge two JSON files using JQ using the key Email_Address as the match between the two datasets.

Updated over 6 months ago

Easily merge two JSON datasets based on a common Email_Address key with our workflow template. This solution demonstrates the use of JQ to efficiently combine data, creating an array of computers linked to corresponding email addresses. Ideal for simplifying data aggregation in applications where user and device information must be associated, enhancing data management and reporting capabilities for IT and administrative teams.

Use Cases

null

Workflow Breakdown

  1. Define the two JSON datasets using the variable steps

  2. Apply the JQ command to merge the JSON so that computers are an array based on the email address.

Vendors

Utils

Tips

Modify the JQ command to provide the desired output. ","In this case the selection is filtered on 4 elements found in the computers JSON data where the email address matches

Did this answer your question?