Jump to content

Variable from a cell in data table


Roman Lyakhovetsky

Recommended Posts

Hi Everyone,

I did a search in the forums and did not find the answer to my topic so far, apologies if this was previously discussed already.

Can I assign a variable name to a cell in data table for it to be used in custom expression for other data table

Thank you very much in advance,

With kind regards,

Roman

Link to comment
Share on other sites

The only way I have found to do this is add the column using the "insert column" feature, and pull from the other datatable. I have done the following:

Table 1

Table 2

Create Transformation on Table 1 (add new customized Column)

Insert Column on Table 2 (select the tranformed column to pull over)

This will add the column to the new data table to use as you like.

The other thing you can do depending on your use case is in a cross table you can reference other datatables if you have the column matches set and showing.

https://docs.tibco.com/pub/spotfire/6.5.1/doc/html/md/md_column_matching...

https://community.tibco.com/questions/difference-between-manage-relation...

If you use column matches the details on demand will not show the 2nd Data Tables columns, so you would need to set up a table visualization if you wanted to be able to drill down to the Details.

Link to comment
Share on other sites

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...