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

sushil353 — Thu, 12 Jan 2012 09:57:26 GMT

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.

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

vijay_iitkgp — Thu, 12 Jan 2012 10:14:51 GMT

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

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

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

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