Order of data in DTP
Can you clear up my confusion please.
I am transferring data from one DSO to another DSO in an attempt to perform a merge. The records in DSO1 have been modelled incorrectly so one logocal record can appear as 2 physical records. These get merged when going into DSO2.
However I need to control the order of the data so that the data can be overwritten correctly. I was intending to use Semantic Group functionality to achieve this. When I press the Semantic Group button the list of fields is displayed but I cannot tick any of them. Is there an OSS note for this or am I not using this option correctly.
Instead I have found that changing the 'Extraction from' setting also changes the order. The default was Active Table (without Archive) and this yielded the wrong results. Setting it to the Change Log appears to give the correct results (need more testing).
Can someone explain how to use these settings and what impact they have please ?