2 Replies Latest reply on Sep 23, 2019 3:12 AM by Jonas Eckhardt

    Using Extract API (Python) to create extract file with multiple tables

    Michael Liu

      Hi,

       

      Can I have a piece of example code using Extract API to create an extract file with multiple tables?

      Say, I want to create a extract file TestPyDataSource3.hyper.

      I have three tables in my database, BASE_VIEW, BAU_STRESSED_CE_VIEW, CHILD_VIEW. Joinings will be

      BASE_VIEW LEFT JOIN BAU_STRESSED_CE_VIEW ON BASE_VIEW.Field1 = BAU_STRESSED_CE_VIEW .Field1

      BASE_VIEW LEFT JOIN CHILD_VIEW ON BASE_VIEW.Field1 = CHILD_VIEW.Field1

       

      I'm expecting that after I load this hyper file in Tableau, I should see my data source like this:

       

      Is this even possible?

       

      Thanks,

      Michael