This content has been marked as final. Show 5 replies
Apply outer or complex join in the BMM layer based on the tables placement.
mark if helpful/correct..
In column formula use
IFNULL( "Column name", ' ')
mark if helpful/correct.
If these are physically mapped then change the join inner to to Left outer or else you can go with
For logical source 'product p1' properties->General tab
Click on Add button and select ' product_group p2' and set Type as 'Left Outer'
If these tables are with complex join then double click on join mapping to get join wizard->Select table at 'Driving' and 'Type' Left outer or Right Outer.
Do these in BMM layer.
If helps pls mark
I tried all the possibilities given.
All the values are coming until I pass the dates. When I pass the dates since there is no date for record C in Table2, its not coming.
Sudha777: For which column I should keep null..? Date Column..?? I tried to keep NULL for date but it throws error. How to keep NULL for date column...??
You can try to use IfNULL() any of the columns.
Since, you get error when you used it on date, you can try that on column2.
mark helpful/correct if it helps