Skip to Main Content
Spotfire Ideas Portal
Status To be Reviewed
Product Spotfire
Categories Data Access
Created by Guest
Created on Jun 18, 2024

use parameter as identifier in Information link SQL

From time to time, we receive requests from our customers that they want to load data from database where table name is dynamic, e.g. on demand load data from different tablenames all of them have the same column structure.

Unfortunately currently IL doesn't support using parameter as identifier, string parameter is always interepreted as literay so SQL like [ select * from ?tablename ] results in [ select * from "table1" ] which is not an legal SQL statement.

  • Attach files