https://community.qlik.com/t5/Talend-Studio/Check-data-from-DB-on-tmap/m-p/2295078#M67897 <P>Hi <BR />You need to do an inner join between lar and Base_Country table on tMap based on city column to get the country value from Base_Country table. The job looks like:<BR />tmysqlinput(lar)--main--tMap---....<BR />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;|<BR />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;lookup <BR />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;|<BR />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;tmysqlinput(Base_Country )<BR />Regards<BR />Shong</P> Fri, 11 Aug 2017 06:58:09 GMT Anonymous 2017-08-11T06:58:09Z https://community.qlik.com/t5/Talend-Studio/Check-data-from-DB-on-tmap/m-p/2295077#M67896 <P>I have a question (look the attached image).</P> <P>In the same DB i have 3 tables: lar, Base_Address, Base_Country.</P> <P>The job that I create have "lar" table&nbsp;as input, a tMap and "Base_Address" table as output. Goal is to migrate data to the new structure.</P> <P>The problem is that the output table ("Base_Address") have more fields, for example country, and I need to keep this data from Base_Country table. I can obtain the value of country searching it into Base_Country table with city parameter.</P> <P>Target is to fill province, city (both from "lar") and country of Base_Address table, how can i do that?</P> <P>&nbsp;</P> Thu, 10 Aug 2017 22:38:58 GMT https://community.qlik.com/t5/Talend-Studio/Check-data-from-DB-on-tmap/m-p/2295077#M67896 Anonymous 2017-08-10T22:38:58Z https://community.qlik.com/t5/Talend-Studio/Check-data-from-DB-on-tmap/m-p/2295078#M67897 <P>Hi <BR />You need to do an inner join between lar and Base_Country table on tMap based on city column to get the country value from Base_Country table. The job looks like:<BR />tmysqlinput(lar)--main--tMap---....<BR />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;|<BR />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;lookup <BR />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;|<BR />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;tmysqlinput(Base_Country )<BR />Regards<BR />Shong</P> Fri, 11 Aug 2017 06:58:09 GMT https://community.qlik.com/t5/Talend-Studio/Check-data-from-DB-on-tmap/m-p/2295078#M67897 Anonymous 2017-08-11T06:58:09Z