Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Thanks S.
I actually just found the issue. I rapped both in a text() function and not they are linking appropriately.
Steve
Steve -
I am glad the issue is resolved for you.
Have a good one.
Best,
S