Concatenate Array
Infoveave Data Automation — JSON & Array
Product tags come from two sources — a PrimaryTags array and a CategoryTags array. You need one Tags column with all of them merged. Select both columns, name the output — merged.
Array concatenation is a common need in pipelines that aggregate lists from multiple sources — combining user-assigned tags with system tags, merging sensor reading batches from consecutive collection windows, joining feature vectors from multiple models, or consolidating matched record identifiers from multiple lookup results. Performing this concatenation requires list addition in Python, ARRAY_CAT in PostgreSQL, ARRAY_CONCAT in BigQuery, or JSON_ARRAY_APPEND in MySQL — all database-specific and requiring code changes when the column set changes. Concatenate Array merges any number of JSON array columns in one configured step, without specifying element types or writing platform-specific array functions.
What Concatenate Array does
Merge two or more JSON array columns into a single concatenated array column in Infoveave. Combine tag lists, measurement sequences, feature vectors, or any ordered array data from multiple columns into one unified array without Python list addition, SQL ARRAY_CAT, or manual JSON string manipulation.
When to use Concatenate Array
- You have product or content records where tags, categories, or labels are stored across multiple array columns — such as PrimaryTags from one system and CategoryTags from another — and you need a single unified Tags column for search indexing or filtering
- You are building a feature vector concatenation pipeline where different model outputs or feature extraction steps each produce an array column, and you need to combine them into one feature vector array for downstream model training or scoring
- You are merging time-series batches where consecutive reading windows are stored as separate array columns per row and need to be joined into a single continuous array for statistical analysis or visualization
- You are consolidating matched IDs or lookup results from multiple lookup steps where each step produced an array column of matched values, and you need to combine them into a single comprehensive result array
When to avoid it
- You need to extract a single element or a slice from one array column rather than merge multiple arrays — use Extract from Array for positional extraction
- You want to combine flat columns into a JSON object rather than join arrays — use Create JSON Object for key-value JSON packaging from flat columns
- Your arrays need to be deduplicated after concatenation — Concatenate Array preserves all elements including duplicates; add a subsequent deduplication step to remove repeated values
Where it fits in your Infoveave automation
Concatenate Array is one step inside a multi-step Infoveave workflow. Chain it with other activities — no code, no manual hand-offs.
Build this workflow visually in Infoveave Data Automation — drag, connect, and schedule with no infrastructure setup.
How teams use Concatenate Array
Real scenarios where this transformation saves hours of manual work.
Merge Primary and Category Tags into a Single Product Tag Array
A retail merchandising team maintains product records where product tags are split: PrimaryTags contains manually assigned tags from the buyer team and CategoryTags contains auto-generated category tags from the taxonomy system. The search indexer requires a single Tags array per product. Concatenate Array merges PrimaryTags and CategoryTags into a unified ProductTags column containing all tags from both sources, preserving order with manual tags first.
Join Consecutive Sensor Reading Batches into a Continuous Measurement Array
A quality control pipeline collects vibration readings in two consecutive 10-minute windows, storing them as Window1Readings and Window2Readings array columns per equipment record. Statistical analysis requires the full 20-minute sequence as a single array. Concatenate Array merges Window1Readings and Window2Readings into a FullReadings array column for the statistical step.
Combine Alert Flag Arrays from Multiple Detection Engines
A risk monitoring system runs two detection engines per transaction: a rule-based engine producing RuleFlags and a model-based engine producing ModelFlags, each as an array column. Compliance reporting requires all flags combined in one AllFlags array per transaction. Concatenate Array merges RuleFlags and ModelFlags into AllFlags, which the reporting step uses for flag count, severity sorting, and alert routing.
See Concatenate Array in action
Input data (left) is transformed using the configuration below. The output table (right) is ready for dashboards or downstream steps.
PrimaryTags, CategoryTagsAllTagsYesInput Data
| ProductID | PrimaryTags | CategoryTags |
|---|---|---|
| P001 | ["organic", "premium"] | ["dairy", "fresh"] |
| P002 | ["gluten-free"] | ["bakery", "vegan"] |
| P003 | ["imported", "specialty"] | ["condiments"] |
| P004 | ["local"] | ["produce", "seasonal", "fresh"] |
| P005 | ["bundle"] | ["electronics", "accessories"] |
Output Data
| ProductID | PrimaryTags | CategoryTags | AllTags |
|---|---|---|---|
| P001 | ["organic", "premium"] | ["dairy", "fresh"] | ["organic", "premium", "dairy", "fresh"] |
| P002 | ["gluten-free"] | ["bakery", "vegan"] | ["gluten-free", "bakery", "vegan"] |
| P003 | ["imported", "specialty"] | ["condiments"] | ["imported", "specialty", "condiments"] |
| P004 | ["local"] | ["produce", "seasonal", "fresh"] | ["local", "produce", "seasonal", "fresh"] |
| P005 | ["bundle"] | ["electronics", "accessories"] | ["bundle", "electronics", "accessories"] |
Configuration
Key fields to configure in the Infoveave workflow builder. Full reference available in the documentation.
Column Names
Select two or more columns, each containing JSON array values. The arrays are concatenated in the order the columns are selected — the elements from the first column appear first in the output array, followed by elements from each subsequent column in order. All selected columns must contain valid JSON array strings.
Output Column
Enter the name for the merged array column. The output is a well-formed JSON array string containing all elements from the selected source arrays combined in sequence.
Include Original
Choose whether to retain the source array columns in the output alongside the merged array column. Disable to remove the source columns after merging if only the combined array is needed downstream.
Frequently asked questions
Everything you need to know about Concatenate Array in Infoveave.
Also in JSON & Array — and what runs before & after
Transformations in the same family as Concatenate Array, often chained together in the same Infoveave workflow.
Part of Infoveave Data Automation
80+ transformations. Zero manual steps.
Concatenate Array is one of over 80 transformation activities available inside Infoveave workflows. Chain transformations together — no code, no exports, no waiting for IT.
Ready to see Infoveave in action?
