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]

[Jose Leviaguirre]

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

[Venkata Siva Komma]

Hi Jose,

Thank you for your tip.