This content has been marked as final. Show 2 replies
Situation: I want to Join OrderId table with Main_Table by [Number] field.
I want to record Channel/Source/Campaing values from OrderId to the Main_Table (currently there are no values there), where Map = Table2
Left Join (Main_table)
'Table2' as map,
Drop Table OrderIdSourceTMP;
The problem is that the tables are not joined because Channel/Source/Campaign in MainTable are considered to exist, although they equal to zero.
Is there a magic sauce?