I'm trying to figure out how to bring in the gaps for the dimension "Branch". Branch is in a header table while the GL Detail Account Number and Account Desc Category are in a detail table.
So, I thought doing a left join into the detail table would resolve this issue but I'm still seeing these gaps.
bga_acct_cl as [Account Class Code Key],
bga_bsc_gl_acct as [GL Detail Account Number],
Pick(left(bga_bsc_gl_acct,1), 'Asset', 'Liability', 'Equity',
IF (left(bga_bsc_gl_acct, 2) < 43, 'Revenue', 'Expense'),'Expense', 'Expense', 'Revenue', 'Expense')
as [GL Account Desc Category]
FROM [lib://QVD Files/Extract/GLDetail.qvd]
Left Join([GL Detail])
gld_bsc_gl_acct as [GL Detail Account Number],
left(gld_sacct,3) as [Branch]
FROM [lib://QVD Files/Extract/GLTransactions.qvd]
Any insight or help to resolve this would be greatly appreciated!