Spotfire Ideas Portal
Currently I don't see an option in Create Calculated Columns dialog box to create calculation based on data from other tables. It would be a lot helpful to have this feature especially when you want to create calculations based on data from multiple tables.
I know another way to do this is to join the tables but that is not efficient when there are huge tables.
Thanks Karan, we need to join the tables to execute the calculation but I understand the benefit of the user not having to perform the join. To do the join on the fly with the calculatin would require the same row count in both tables however. It would be intereting to learn more about the problem that should be solved. Thanks, Thomas