I am trying to add 2 tables in a single tableau extract using the tableau dataextract API.
I have two tables - one aggregate table and one dimension table. Generally, I join these two tables when importing the tables using tableau desktop using the "multiple tables" option. I need a way to accomplish the same using the API without having to join these tables inside my database.
I have tried to do this by using the "extract.addTable" function twice on the same extract. But that does not help.
Is there a way to do this?
No, it can only contain a single table - you must "join" the two tables together yourself before you provide the final result to Tableau.