Spotfire Ideas Portal
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.
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 A 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.
Is it an Excel file with multiple tables? Should they all be added at all times?