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

[SJin1698390552]

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

[Anonymous]

Hi

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