Can datasets be merged in Auto Insights?

Last modified: March 25, 2022

How to join, merge and combine datasets in Auto Insights.

Can I merge two (or more) datasets in Auto Insights?

Yes, it is possible to merge, join and combine datasets in Auto Insights. However, the option is only available to users who are connecting, or have connected Auto Insights directly to a database. 

Auto Insights' database connection functionality allows you to use SQL query statements to merge, join or combine datasets to be ingested into Auto Insights, or include logic that is currently used in your reporting.

Add Database Connection

Using SQL query statements allows you to control and specify the joining criteria (e.g. INNER JOIN, FULL JOIN, LEFT JOIN or RIGHT JOIN).

Dataset Merging Best Practices

If your query statement is particularly complicated or greater than 64,000 characters, it may be more practical for you to capture the logic in your database via a new table or view. You can then connect Auto Insights directly to this table.

Was This Page Helpful?

Running into problems or issues with your Alteryx product? Visit the Alteryx Community or contact support. Can't submit this form? Email us.