Jump to content

Information link using freehand sql

Manoj Chaurasia

Recommended Posts

Hi ,


I am creating a info link using freehand sql,


first I have created data elements and then I have created Information link on that but I want some changes in the original sql.


1. How can I insert a column 2 times, I tried but I am getting only one time


2. In free hand sql I had a Group by clause , how to do it in spotfire


If I put simply Group By as normal sql It is giving me error while loading data.




Link to comment
Share on other sites

thank you John,


But I tried to add column 2 times in the data elements, but 2nd time "add" button is grayed out , I can't able to add it to the data elements twice.


and in informationlink using free hand sql by adding same column with different name 2 times also , i am getting only one time when I load the data in to the report.( I am guessing this because in data elemts column present one time even in original sql or using free hand sql also you can able to use the column only one time ....I am not sure)


I didn't tried by changing names while adding into the data elements . I need to try..But I don't see any option to change the name while creating data elements.

Link to comment
Share on other sites

  • 2 years later...
  • 4 years later...

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...