Noah Holihan Posted June 26, 2019 Share Posted June 26, 2019 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! Link to comment Share on other sites More sharing options...
Kirsten Smith (she/her) Posted June 26, 2019 Share Posted June 26, 2019 Add a Pivot transformation to put Columns A and B for each date on a single row, then you can do the necessary multiplication. Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now