Keys not joining properly (no fields from the dimension table)

[zagzebski]

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?

GL TABLE:

GL Account   Description

10065               Cash

TRANSACTION TABLE:

GL Account  Amount

10065               $100

CHART:

GL Account   Desc     Amount

10065              -           $ 100

Thanks in Advance,

Steve

[sunny_talwar]

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.

Best,

S

[zagzebski]

Thanks S.

I actually just found the issue. I rapped both in a text() function and not they are linking appropriately.

Steve

[sunny_talwar]

Steve -

I am glad the issue is resolved for you.

Have a good one.

Best,

S