Keys not joining properly (no fields from the dimension table)
I have a Transaction table with the GL Account field and a GL Account table..
I have never had this happen but the fields won't join. Note the two tables below. But then when I create the chart it must not be joining because for account 10065 it WON'T pull in the Desc field. Is it something to do with the formatting of the GL Account field?
Re: Keys not joining properly (no fields from the dimension table)
When you join the two tables, do you get two rows of data (duplication of GL Account 10065)? If not, then I don't think join is an issue here. Can you share a sample document or at least your script, so it can be troubleshooted.