1 Reply Latest reply on Feb 6, 2019 10:36 AM by Santiago Sanchez

    Tableau In Memory Database Utilization

    Vinay Aditya Reddy

      Hi,

      I have a requirement where i will be receiving multiple xml files per hour that have to be converted to excel and load the data into Tableau In-Memory and generate a Dashboard.

      After converting to excel each sheet contains more than 5000 rows per hour.

      But my concern is excel can handle data around 400,000 rows.

      How can i use the excel as data source for long run and how can i properly utilize Tableau In-Memory Database for this requirement?

       

      And also here we dont have option for an ETL or DB/ODBC connection.

      Source would be Excel only.

       

      BTW i have converted the xml to excel using python scripting.

       

      Suggestions would be appreciated.