Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
When I left join Table 2 to Table 1 the Amount becomes null any particular reason.
Table 1 Table 2
ID ID
Branch Amount
Dept
Date
see the attached file
hope it helps
Probably because there are no overlapping ID's and you are doing left join
If there are overlapping ID's double check that the formatting is the same.
Dont use a table alias for the 2nd table. Please see attached mate
Cheers,
Byron
Hi,
Table 1 Table 2 Table 3 Table 4
ID ID CID CID
Branch Amount ID Balance
Dept Dept
Date Date
Table 1 (LEFT JOIN ) Table 2 (CONCATENATE) Table 3 LEFT JOIN Table 4
Now the Balance becomes a null field but when I remove the concatenate the Balance has values. And I want just a big FACT Table.
Originally you gave us 2 tables to work with now you have 4. If your requirement has changed please let me know exactly what you working with and what your desired output would be, then I can put something together for you
reason is that no any id are common in both table. so amount display null.
(thumbsup)
Sorry about that initially I thought it was overlapping ID's as Anders Møller stated but i realised it has to do with the model. The above is the requirement I went to merge all into one Fact Table as the desired output.But it seems the Balance field becomes null when i use my approach.Help
But there is CID in Both Table 3 and Table 4...........so when i select CID is should relate to the Balance right?