Remove 'duplicated' records from a tree

[twanqlik]

I'm try to update my load script in such a way that from the below table i will only load the green records and skip the red records.

Anyone an idea how i can do this? 

I've attached an excel sheet with example records :). 

[rwunderlich]

Do you mean literally exclude those that have a red background in the excel file? Or is there is some data rule that identifies the red records?

-Rob

[twanqlik]

Ah sorry.
In this example the AssetID is unique and this asset is mapped to several 'businesses'.

Level 1,2,3,4 and 5 give information to which business an asset is assigned to.
Level 1 is the highest level, level 5 is the lowest level.
Level 1 = business, level 2 = sub business etc.

These levels will be used as a filter to drill down for the user.

The red records have no value in this dataset, because e.g. on the first row you can see that the asset falls under:
Fancy | Shaver 6000 | 3. Foundation | b. Photography

The second, third and fourth record share the same data but lesser:
Fancy | Shaver 6000 | 3. Foundation
Fancy | Shaver 6000
Fancy

However, i don't need these records in my datamodel, as this information is already available in the first record.

Hope this clarifies?