I'm trying to create a list where:
(a) There are two levels in the hierarchy, let's say "Level 2" and "Level 1", where Level 2 consolidates up into Level 1;
(b) Level 2 and Level 1 are both numbered lists with a display name property
(c) The members of the lists will be added to over time, and I want to update the members and their consolidations from a CSV that has two fields, representing Level 1 and Level 2.
(d) The fields on the CSV match up with what's in the Display Name property of the two levels.
(e) In a small number of cases the length of the fields is greater than 60 characters, which is why I'm trying to use numbered lists.
I'm trying to do build/update the lists by importing the CSV into the list that represents the lower level (Level 2), but how do I set up that import? I've tried it as follows in the Anaplan Import dialog box:
Nothing maps to LEVEL 2
The field for LEVEL 1 maps to Level 2's "Parent"
Nothing maps to Level 2's "Code"
The field for LEVEL 2 maps to Level 2's "Display Name"
Items uniquely identified by "Combination of Properties" (specifically, "Display Name")
This doesn't work; Level 2 items don't get associated with the right Level 2 parent, and indeed I get an "invalid parent" error. I can understand this, because I'm not putting the real Level 2 key into the parent field, I'm putting the Display Name in there, but it's the only identifier I've got.
Is this possible to do correctly?