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

Calling Talend Open Studio Users

The first 100 community members completing the Open Studio survey win a $10 gift voucher.

Start the survey

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Download