Greetings,

I attached a screenshot of what I am trying to achieve. In a tMap I have my main table and two lookups. The first table holds and ID that is connected to the first lookup table. The second table has a String Description that I connected to the second lookup table. From the second table I want to use a BigDecimal in the output of my flow. Not every row is going to contain a lookup from the 3rd table, so it is not necessarily an Inner Join.

Is there something wrong with my logic here? Is this not possible? Any help would be greatly appreciated.

thank you!