topic Clearing synthetic tables in QlikView

Clearing synthetic tables

ranibosch — Wed, 22 Nov 2017 09:01:00 GMT

Hi,

I've got a model which has got synthetic tables, but this is due to a number of sub ledgers that i need to link to each other:

For each of the above mentioned I have to bring in the year, business unit and responsibility center in order to report accurately.

How do I clear this synthetic table that consists out of the year, business unite and responsibility center?

PrashantSangle — Wed, 22 Nov 2017 09:09:19 GMT

create key of those field and rename those field.

link table will help you.

search on community there are so many threads available to solve it.

Regards,

petter — Wed, 22 Nov 2017 09:16:29 GMT

1) In your load script create these calculated field for both the GeneralLedgerEntries and ItemLedgerEntries tables:

Autonumber(Year &'|'&BU&'|'&[Responsibility Center]&'|'&[Document No],'YBRD') AS %YBRD,

Autonumber(Year &'|'&BU&'|'&[Responsibility Center]&'|'&[Document No],'YBR') AS %YBR

2) Add this calculated field in the load statement for the BudgetEntries table:

Autonumber(Year &'|'&BU&'|'&[Responsibility Center]&'|'&[Document No],'YBR') AS %YBR

3) Then avoid including the fields Year, BU, Responsibility Center and Document No from the ItemLedgerEntries table.

4) Reload and see if the $Syn 3 Table disappeared.