Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
valera_sh
Creator II
Creator II

Partial hierarchy reload problem

Hi guys,

I have HIERARCHY LOAD statement in the script which works fine in full reload mode and in my case produces a table MyHierarchy of 12 fields for hierarchy levels.

Now I need to externally update the source parent-child table to recreate the hierarchy table with HIERARCHY LOAD statement in partial reload mode. And this seems absolutely impossible.

Firstly, in partial reload mode both
REPLACE HIERARCHY (...) LOAD ... and
HIERARCHY (...) REPLACE LOAD ...
statements produce another table MyHierarchy-1 with already 16 fields for hierarchy levels which is wrong.

Secondly, if I try to drop the table MyHierarchy before partially reloading the data the REPLACE HIERARCHY LOAD statement produces a table with just 1 field of hierarchy level.

Of course, the data in the source parent-child table remained intact during these tests.

It really seems that the HIERARCHY LOAD statement works absolutely differently in full reload and partial reload modes. Or am I wrong somewhere? What is the way to partially reload the tables with HIERARCHY LOAD and HIERARCHYBELONGSTO LOAD statements?

Any suggestions are highly appreciated. 🙂 Thanks.

Valera

0 Replies