You are not logged in.
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.
Well, it seems like this was resolved by trimming both the inputs for the String look up.
I never thought that would have been an issue!
Why do I have to trim the String? There should be no reason to do this.
Last edited by jkrfs (2011-07-08 17:46:50)