Skip to Main Content
Spotfire Ideas Portal
Status Planning to implement
Categories sql support
Created by Guest
Created on Mar 8, 2023

When I process a JOIN key item in the SQL panel and regenerate the model, the join line is not displayed correctly.

When I create a query in the SQL panel with the following join keys processed and then regenerate the model, the join line is displayed in a position unrelated to the columns.
Could you please fix it so that the line connects at the column specified in the SQL?
SELECT 
right(tbl01.col1, 2) a,
tbl01.col2,
tbl02.col3
FROM
tbl01
INNER JOIN
tbl02
ON right(tbl01.col1, 2) = tbl02.col1

Could you please fix it so that the line connects at the column specified in the SQL?
  • Attach files