What is the Data Union feature?

Data blocks allow you to pull data from multiple accounts/cloud platforms in Tableau in one query. The Cognetik Cloud Connector essentially mashes up multiple data extracts into one data extract, which simplifies the setup and management of these data extracts.

Learn more about Data Blocks in this article.

To use Data blocks, you basically fill in two separate queries in one extract. When you submit your query, your data is returned in one table, with a separate column for each parameter in the query per data block.

To go even further than this, we’ve now added the ‘Data Union’ feature which gives you the possibility to merge two data blocks into one single table header. This means that if you query data from different accounts, the matching parameters will be aggregated in one column. This comes in handy if you want to aggregate data from different accounts.

To better understand how this feature works, we’re going to submit a query with two data blocks (same query from two different Facebook Pages accounts), with and without the Data Union feature.

Query 1 

Data Blocks without the Data Union feature

Data block A - Facebook account A

Data block B - Facebook account B

This query will return your data in separate columns (different column for the same parameters based on data blocks)

Query 2 

Recreate Query 1 (two Data blocks) with ‘Data Union’ box checked

Ticking the Data Union box will merge your data blocks into one single table, with one column per parameter, across your data blocks.

Did this answer your question?