Information Link EDIT SQL for Default value alias names

Hello Every One,

Hope you are all doing great. Actually i was trying to edit the Information link SQL. But i was not able to fetch the results for the default value colums. Please find the example below.

select A."Name" as "Name", "Asia" as "Region" from "Table" A.

 

Expected Result:

Name Region
Vidya Asia
Sagar Asia

However when i tried to edit the SQL information link i was able to save the IL without any errors. But when i am opening the data for the IL i am not seeing the "Region" column.

Output from IL:

Name
Vidya
Sagar

Spotfire Version: v7.6

Thanks,

-Vidya

(1) Answer

Login