topic INNER JOIN for TDBINPUT 1 (JDBC) and TDBINPUT 2 (SQL Server) in Talend Studio

INNER JOIN for TDBINPUT 1 (JDBC) and TDBINPUT 2 (SQL Server)

SJin1698390552 — Fri, 15 Nov 2024 21:17:49 GMT

Hi i am facing issue to inner join my two TDBINPUT, for Agent_Code in SQL Server db should have value like JB1234, while for ZZSBRANCH will be JB and ZZSCODE will be 1234, for me to compare the value of Agent_Code = ZZSBRANCH + ZZSCODE, what should i do, this is my TMAPhow should the query for tdbinput be like? SAPABAP1 as the first db, [NirvanaCRM].[dbo].[Agent_Path_Upline] as the second db (SQL Server), please ignore upper part and focus on the highlighted part in image

Re: INNER JOIN for TDBINPUT 1 (JDBC) and TDBINPUT 2 (SQL Server)

Anonymous — Mon, 30 Oct 2023 06:18:01 GMT

Expresssion row1.ZZSBRANCH +row.ZZSCODE will concatenate two string, eg:

"JB"+"1234"==>"JB1234"

In your query, the condition is

A.ZZSBRANCH || A.ZZSCODE=N.Agent_Code

These are two different logics, and the results are also different. If you want to get the same result using tMap as the query does. Do the inner join two times, one for ZZSBRANCH and the other for ZZSCODE, merge the two output results, filter the duplicated rows.

Regards

Shong