Jump to content

Hi I have two separate tables. in my final table I need to add the test time from both tables based on the type.

Venkata Siva Komma

Recommended Posts

  1. Create a new data table from current analysis called Final Table and add Table 1
  2. Add testtime2 columns from Table 2 using a Left outer join matching the "type" columns on both tables
  3. Calculate a new column transformation called "Total time" and add "[testtime1]+[testtime2]" expression
  4. Exclude the testtime1 and testtime2 columns by doing another transformation an you are done


Link to comment
Share on other sites

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...