Code not linked

[Anonymous]

Dear All,

I am get confused that why Am not getting bud vs Act data in one line against GL code. where GL codes present in both tables .

Thanks

[sunny_talwar]

May be use GL_CODE_LINK as your dimension?

[stabben23]

Do as Sunny describe, but you have a lot of "mismatched" account in there.

[asgardd2]

I think, that you have a mistake in the script.

In first load you was create two same fields with different names.

[stabben23]

But thats the key for concatenate the tables, nothing wrong With that.

But EntryNo have nothing common and should not be concatenated With the same name.

[stabben23]

Ok, I'll think I see why you have some mismatches here, you only load First 5000 rows.

But have a look at EntryNo, as it is right now and you Select a EntryNo you will get total mismatch on Accontfields from Budget and GL_Entry. Rename the Field if its not a common key.

[asgardd2]

I mean,that mistake in second table There are not field GLAcc-Code in second load, consequently we can see 2 rows in chart. (because value in second row is null)

[stabben23]

Hmm, This is normally used when you test Your data. When you concatenate you need to have common keys in this case GL_CODE_LINK.

GLAcc_Code is to know that this account is from GL_Entry table

Budget_Acc to know which account who is from Budget table.

You could use Flag but sometimes it could be greate to see the keyvalue from both tables.

These Fields could be droped or commet awy later on.

You will always have 2 rows on the accont when concatenate otherwise you need to join. But in this case concatenate is the correct way.

If he shows correct Dimension GL_CODE_LINK it will be one row in the chart.

[asgardd2]

Yes, thank you for your explanation, I understand what you mean.