Hierarchy with left keep

[#1]

Dear All,

I'm using hierarchy function to group accounts and link them to transactions table. Unfortunately, "left keep" function that links accounts table with transactions (Account_ID is the key) intereferes hierarchy - only one group is built instead of four. Please see the code and help:

AccountsTable:

LEFT KEEP (TransactionsTable)

LOAD Account_ID, Parent_ID, Account_Name;

HIERARCHY (Account_ID, Parent_ID, Account_Name)

SQL SELECT "Acc_AccId" AS Account_ID,

"Acc_Nazwa" AS Account_Name,

"Acc_ParId" AS Parent_ID

FROM "CDN".CDN.Accounts;

AccountsTable:

LOAD Account_ID, Parent_ID, Account_Name;

HIERARCHY (Account_ID, Parent_ID, Account_Name)

RESIDENT AccountsTable;

Thank you,

Przemek