How do i replace data of a table field using another table field?

[sushil353]

Hi All,

I have two tables , say Table 1 and Table 2.

Table 1 contains some test types(TT_TYPE) correspond to TT_TYPE some measurements are written in table 1

Table 2 contains "RUNTIME_ERROR_OCCURED" test type only and corresponding measurement.

i want to repalce Table 1 measurement with table 2 measurement where TT_TYPE in table is "RUNTIME_ERROR_OCCURED"

Please find the attached application and images.

[vijay_iitkgp]

Hi, You can join two tables on External Id and then use if condition like if(BSN.ME_MEASUREMENT=0,ME_measurement,BSN.ME_MEASUREMENT) AS Target_Measurement