This content has been marked as final. Show 2 replies
You should use a mapping load with an ApplyMap(), as follows:
Table2Map; MAPPING LOAD b_id, dept_id; // b_id or the unique identifier between both tables SQL select * from tab1; Table1: LOAD f, g, j, kk, b_id, If(dept_id = 'global', ApplyMap('Table2Map', b_id), dept_id) AS dept_id_new; SQL Select * from tab1;
Hope that helps.