Spotfire script append rows without adding columns

[V S]

Hi,

I am trying to add all rows from Table B into Table A.

Both tables have some calculated columns added (same names)

When using 'addRows' and AddRowsSettings in script to add rows from one table to another it creates additional calculated columns such as calcCol(1) and so on.. any idea how can I not add extra/duplicate columns

Thanks

[Fabian Duerr]

Can you try to use the following method to create your calculated column:

 

Instead of Insert -> calculated column you use Insert -> Columns... then pick the same data table as source and chose the transformation 'calculate new column' and click 'add'. Type your formula for calculation there. 

 

The difference with this approach is that the calculated column is no longer dynamical. The values are fix (static). This column is treated like any other column.

 

As long you have a dynamical column you can't merge data on this column.

 

(If both of your tables have the same calcualtion, then just merge the tables first and do the calculation afterwards)

[Shandilya Peddi]

Have looked into the following AddRowsSettings constructor where you can add list of columns that should be ignored,

https://docs.tibco.com/pub/doc_remote/sfire_dev/area/doc/api/TIB_sfire-a...

[V S]

I tried using this approach but did not quite get the use of 

 

rowSourceColumn and 

 

newRowSourceValue

 

Any example would be great

 

DOes it mean an extra column is added to the source data col