Skip to Main Content
Spotfire Ideas Portal

How to automate import new tables to spotfire

Hi Team,

Currently, we are pulling tables from smartsheet to Spotfire by using query and performed some analysis,

In smartsheet on a daily basis new tables will be added, so every time we have to pull the new tables from smart sheet into Spotfire.

Is there any way to automate these activities without opening the dashboard by using sql query?

it will save a lot of time.

  • Attach files
      Drop here to upload
    • Guest
      Reply
      |
      Aug 14, 2019

      Hi Thomas,

      Thank you for your response,

      It's not an Excel file, we are using smartsheet database(where multiple tables will be stored)

      On a daily basis it will be added into the database, Let's say there are two tables A and AB available in Smartsheet.

      We pulled those Tables into Spotfire using SQL as SELECT
      "Table A".*
      FROM
      "Table A" and 

      SELECT
      "Table AB".*
      FROM
      "Table AB" 

      Under Table A we will be having one column as Sheets added(Yes/No)

      if a new table AC is created into the smartsheet then they will Mark in Table under Column Sheets Added as Yes. 

      If we find Yes within that column then we have to pull that table into Spotfire.

      Could you please help us with any solution for this?

      Thank you in advance.

       

    • Guest
      Reply
      |
      Aug 14, 2019

      Is it an Excel file with multiple tables? Should they all be added at all times?