TIBCO Spotfire Table Manipulation

[Jewelson Cagakit]

Needing help on how to perform Column Merging and Row Merging in Tibco Spotfire Desktop client. Can't see any funcitons related to it after navigating all the ribbons available.

OR

does it need to be written in terms of MODS to make it happen?

Thank you for your help.

[Gaia Paolini]

column merging can probably be achieved via a calculated column, e.g. using the Concatenate function. Row merging would create a different table with fewer rows, so I guess it is a job for a data function. If you have a specific problem, please can you elaborate and give an example, so we can formulate a more precise answer.

[Jewelson Cagakit]

Hi Gaia,

Look at the example from the attached image,

I would like to do merging of rows so the ic will be on the middle merging 7 rows.

[Gaia Paolini]

unfortunately the attached image is pretty much empty

[Jewelson Cagakit]

Hey Gaia,

Here's the picture.

Essentially, what I am trying to achieve here is for example, Product Line "IC" needs to be merged to cover Disposition Names of Valid, EOS, Good, NK, Invalid-Others, IC Period (Actual), IC Period Goal.

And so on for the rest..

 

[Gaia Paolini]

Do you want your data table to have one row per Product Line and look like this:

Product Line  Disposition

IC       Valid, EOS/EIPD,Good...

AUTO      Valid, EOS/EIPD,Good...

or do you want your data table to have the same number of lines, but Product Line repeated in the empty cells?

[Jewelson Cagakit]

Hey Gaia,

Same No of lines, but the Product Line Column Value is Merged as one cell.

The desired output :

[Gaia Paolini]

Unlike Excel, a Spotfire data table represents the underlying data as it is stored, without a visual component. Every row should have all the columns filled in. In your data table, it looks like you do not have a Product Line associated to most of the rows, and without any grouping columns it is not possible to assign those (e.g. Disposition=EOS/EIPD) to any Product Line.

Maybe you can change the way your table is imported, and if it comes from Excel, unmerge the cells before importing to Spotfire.

[Jewelson Cagakit]

Thank You Gaia for the responses. Noted on this.