In my job, I have where I have two tMaps connected. In my 2nd tMap, I have three rows on the left side. I am successfully able to link row 5 and row 4 on the left side. I have it set as a unique match inner join. Then, when I go to join row 3 to row 5 to join them, it doesn't connect. In row 3, I put row5.Field1 . When I do that, it shows the key, but never really connects the two with the line on the side like the other I connected. I also noticed something interesting in the job. The connection from tMap1 to tMap 2 is a lookup connection. However, on the connection string, it shows an O near the beginning of the connection and an M at the end where it is connected to the second tMap. The other two inputs to the second tMap, show 'L' where it is connected, although, one of those connections is really the main connection. Any idea whey I can't join these rows? When I try to run the job, I get the error, row5 cannot be resolved as a variable.
Just to add. I closed the job and got back in, it now shows an 'L' for the connection of the first and second tMap, but for some reason, I still get the same error and still can't join the two rows.
If you could share some screen shots, it will help to get more insight about the use case. For many of the contributors in Talend community, English is not their main communication language. So a picture will give more idea to them about the actual issue.
Warm Regards, Nikhil Thampi
Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
