Hi to all.
I've imported a file that contains "hierachy" data. The lines in the file are in the correct order:
Line 1 (root): ParentPartyNumber = empty, PartyNumber, = A, ProductNumber = 123
Line 2: ParentPartyNumber = A, PartyNumber, = B, ProductNumber = 123
Line 3: ParentPartyNumber = B, PartyNumber, = C, ProductNumber = 123
Line 4: ParentPartyNumber = B, PartyNumber, = D, ProductNumber = 123
...
The index (IndexOfMyTableIdx) of the table is composed with the following fields: ExceutionId, DefinitionGroup, ProductNumber, PartyNumber.
The "View staging data" shows me the data ordered by the index IndexOfMyTableIdx.
Line 1: ParentPartyNumber = A, PartyNumber, = B, ProductNumber = 123
Line 2: ParentPartyNumber = B, PartyNumber, = C, ProductNumber = 123
Line 3: ParentPartyNumber = B, PartyNumber, = D, ProductNumber = 123
Line 4 (root): ParentPartyNumber = empty, PartyNumber, = A, ProductNumber = 123
The PrimaryIndex of the DMF table is SurrogateKey; the ClusterIndex is SurrogateKey, the ReplacementKey is empty.
When I copy the staging table to the target table, the DIXF uses the sorting by IndexOfMyTableIdx.
I need to import the records ordered by RecId.
(The DMF table is new, not a standard entity)
Any ideas?
Thanks
*This post is locked for comments