Hello! I have the following issue: normally a join in a tMap - component works that way: "luZWHashKey.KURZBEZ = mainrow.khnr;" but what i would need now is some kind of "LIKE" parameter, for example: mainrow.khnr.startsWith(luZWHashKey.KURZBEZ), so no exact match is needed. Is this possible using a tMap? Thanks in advance, Stefan
Hello! Thank you for the answer, but I hope it would be that easy. The join should work if the main rows BEGINS with any value from the lookup row. For example: The main row has a value "ZVKsometext" and on value of the lookup (a database table) is "ZVK", the two should "match". Any ideas?
I would like to do a multi-way join with several database tables and have the resulting rows be an input to a tMap so that I can map the columns from these rows to an output schema. Can I simply associate a single query to a db input component? If so, how?
Hello, I have a issue in mapping the columns in tMap i want to execute the like condition show below, a.column like 'abc%'; based on this condition i update or insert the data in the table. example: i have a table ABC: ID |column1 | column 2 | column3 | column4 |......... 1 |name1 | abc001 2 |name2 | xyz001 3 |name2 | pqr002 i have a condition here if column2 like 'abc%' true i will update the row column2 like 'lmn%' false i will insert new row how can i achieve these kind of condition using tMap ? Thanks, Ashwath.
split flow into 2 with tMap by filters filter for 1 - length(col) >= 3 and (left(col,3)).equals("abc") filter for 2 - length(col) >=3 and (left(col,3)).equals("lmn") flow 1 send to INSERT, flow 2 send to UPDATE this is only example of logic, because You also can decide - what todo with other records? You can make double filter and send both to INSERT/UPDATE