How to multiply two separate columns with the same timestamp in different rows

[Noah Holihan]

Hi all,

I'm having an issue trying to calculate this in Spotfire, where it would be extremely easy in excel. I have a data set that is imported from a source and automatically sets it in a table like the following:

 

 

 

Timestamp

Column A

Column B

 

 

1/1/2019

100

 

 

 

2/1/2019

200

 

 

 

3/1/2019

150

 

 

 

1/1/2019

 

1

 

 

2/1/2019

 

0

 

 

3/1/2019

 

1

 

 

 

In another column I want to have column A multiplied by column B for each of their respective timestamps. For instance, the first row would be 100 * 1, as they bot hcorrelate to 1/1/2019. Any information on this would be great, thanks!

[Kirsten Smith (she/her)]

Add a Pivot transformation to put Columns A and B for each date on a single row, then you can do the necessary multiplication.