Remove all sub levels in a hierarchy structure in the script

[#1]

Hello,

I have a standard parent-child hierarchy with companies.

On the top level (parent) I have a flag that says 0 or 1.

What I want to achieve is that when the flag is 0 at the top level all (parent) companies AND their sub-level (child) should be filtered out of the application.

I can't use;

load

*

from xyz.xls where _flag = 0;

cause then I only get rid of the top-level companies.

Any ideas how I can do it in the script?

[#2]

Bump