Hi All, I have 3 tables: transaction, details, backup. I would like to check: IF (ID in transaction is equal to the ID in details) the address in details table will be imported to the backup ELSE null; How do I do that ? My table is currently join together by transaction --> tMap --> Backup
Hi, Use Transaction as the main flow for the tMap and Details as the lookup. Join both tables in the tMap using the ID column and a Left Outer Join. On Backup flow, populate all columns from Transaction but address from Details.
Hello xdshi, I tried this method also but it didn't work. I have 40 rows in transaction and 5998 rows in details. After I connect the transaction as main and details as lookup to the tmap, the output becomes 239920 rows. I wanted only 40 rows of data for the output. Please help.
@TRF, I have 40 rows in transaction and 5998 rows in details. After I connect the transaction as main and details as lookup to the tMap, the output becomes 239920 rows. I wanted only 40 rows of data for the output. Please help.
@TRF, oh! However, I have ID1 and ID2 in Transaction and only ID in Details. How do I establish the join? The backup table also have ID1 and ID2. Details of ID1 and ID2 can be extracted from ID in details. I tried adding row1.ID1 + row4.ID2 into the expression for ID. However I receive this error message: Exception in component tMap_1 java.lang.NullPointerException
@TRF I think your solution works. It's just that my ID1 and ID2 have NULL values for some rows and thus the following error message appears: Exception in component tMap_1 java.lang.NullPointerException I'm putting row1.ID1 + row4.ID2 as the expression for ID to establish the join. How do I take care of the NULL value?
Your column output.ID is of type int. This is a primitive type and therefore cannot be null. You will see in your table schema a tick box specifying that a column can be nullable. Tick that. It will change your column type from int to the class Integer. An object of class Integer can be null. This should enable the code suggested by TRF.
OK. This seems to show that ticking the nullable tick box fixed that issue. This is a new one :-) Can you take a screenshot of your tMap with the column configurations in view? I would guess that your ID2 column is a short (also a primitive type) and also needs to have the nullable tick box ticked.