You are not logged in.
I need to do a lookup for certain values from a table.I have attached a sample problem for easy understanding.
i need to lookup row1.number1 & row1.number2 against row2.number.The condition is,
row1.number1 and row1.number2 should not be present in row2.number.
If they are not present then the value should be populated in out1, otherwise out1.number1 and out1.number2 should be populated with NULL.
Any help would be highly appreciated.
But I am not sure if this will work according to my requirement because i dont want to loose and data rows.
There can be a case that (row1.number1 != row2.number) and (row1.number2 = row2.number) or vice versa. In this case i want
OUT1.number1 = row1.number1
OUT1.number2 = NULL
I just figured it out that when we are using a lookup table in tmap it will perform a left outer join between the two tables (which is the default join type) wether we specify any keys or not.
hence in this case what is happening is it is making a left outer join between row1 and row2 which is not desirable. I just need all the rows of row1 by looking up the data from row2.