Update column on external source

Hello all,

I would like to update a column of my main data set with data coming from a CSV file where I have only 2 columns, one with a unique reference that is also available in the main data set and one with values that I would like to add in the main data set.

Example

Main data set

ID       Col1 Col2 Col3
ABC   1       2      Empty
DEF   2       3     Empty

My CSV
ID     Col1
ABC 33
DEF 22

I would like to end up with
ID       Col1 Col2 Col3
ABC   1       2      33
DEF   2       3     22

 

Is there a way to do this with Spotfire ? I'm using the online version.

Thanks
Laurent

(1) Answer

Login