Would it be possible for you to take a screenshot of what you already have then give another explanation as to what you would like to do? I don't quite understand what it is you are asking and I think a screenshot of what you have and your explanation reworded might help
From Input I have a look up on target where I load my new and Updated records as two separate outputs on tmap.
I want to have a look up on another table which has an attribute value. I want to have a join between this lookup and my main input and return my attribute value.
Hi @AVINASH MEYYAPPAN , if both userid are from the same type (Integer i hope in your case) , in the TMap input you can drag and drop the value of user id of the main row to the lookup input userid value, it will create a join on those value, then on the lookup you can select inner join and unique match.So if your goal is to insert where you can't find the key : on the ouput insert table properties you can set catch inner join reject to true.
And if you find the key you will update , just make an output for this in the tmap with catch inner join reject to false.
the problem is i already have an output with inner join rejects for my new inserts. This lookup table which has the name has data that matches to my new input. I cannot drag and drop there it would not insert. If I have a new output its complaining about unique constraint violation. Update action did not work either.
HI,i think i understand what you want, on the insert output , send all the data in common for insert and the new output you want ,then youn can use tReplicate component wich will split your output into several other and you make one main for insert, one other main for your table which has "Full Name".
