topic Remove 'duplicated' records from a tree in App Development

Remove 'duplicated' records from a tree

twanqlik — Fri, 05 Aug 2022 13:50:25 GMT

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 :).

Re: Remove 'duplicated' records from a tree

rwunderlich — Fri, 05 Aug 2022 14:45:19 GMT

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

Re: Remove 'duplicated' records from a tree

twanqlik — Fri, 05 Aug 2022 14:51:56 GMT

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?