Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 :).
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
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?