compare columns of two tables and update both the table

One Star

compare columns of two tables and update both the table

Hi ,
i want to compare one column of tables A with one column of table B.  if both column values are not matching then i have to update  both  the tables  with a new field  value 0 or 1.
example.. 
table A:
id|num
1|213
2|415
table B:
id|num
4|H
5|axdl
so in the above two tables i have to  join  on num column.. here the second table contains the value of 1st table column but its in []. so in this case its a match.  
so how to put this logic??
Community Manager

Re: compare columns of two tables and update both the table

Hi
You need to do an inner join on tMap based on num column, please refers to this KB article, for table B, remove all the letters and [] before join.
Regards
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business