Can I merge two (or more) datasets in Anna?
Yes, it is possible to merge, join and combine datasets in Anna. However, the option is only available to users who are connecting, or have connected Anna directly to a database.
Anna’s database connection functionality allows you to use SQL query statements to merge, join or combine datasets to be ingested into Anna, 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 Anna directly to this table.
How do I upload data?
How do I connect to a database?
What sort of data connections does Anna support?
If you have any questions, please contact us at firstname.lastname@example.org.