Solutions · Joomla and WordPress

How do I combine data from several tables or spreadsheets?

A Data Source Merger builds one table out of several data sources: it stacks rows (for example three regional spreadsheets) or places columns side by side, and stays current as the sources change - without exporting or copying anything.

Step by step

1

The Data Source Merger

The Data Source Merger combines multiple data sources of any type into a single table without exporting or manual copying. It explains vertical merging to append rows and horizontal merging to append columns, including when to use each and how they handle mismatched dimensions. The article covers building the Merging Tree workspace with the Available Data Sources palette, nesting groups, the Show/Hide JSON option, and the Clear button, plus behaviors like header row handling, caching, and loop detection.

Data Sources · Read the guide

2

Combine data from multiple tables by using a Data Source Merger

This article explains how to use a Data Source Merger to combine multiple tables vertically by appending rows or horizontally by appending columns. It covers creating merger data sources in the Tabulizer back end, building the Merging Tree by dragging data sources and nesting groups, choosing between Vertical merge and Horizontal merge options, and applying rulesets before and after the merge. It also addresses removing repeated header rows using Data Removal rules and handles common scenarios like source failures and circular references.

Data modifications · Read the guide

See it working

Have a different question?

The knowledge base covers every wizard, data source and option, and we are happy to answer anything it does not.

All solutions Contact us