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.
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.
How do I upload data?
How do I connect to a database?
What sort of data connections does Auto Insights support?
If you have any questions, please contact us at firstname.lastname@example.org.