Hi
I have two data sources that I need to combine but the records from source 2 must be placed in a specific order of position. Example:
Master List:
Item | Description | Position |
Apple | Granny Smith | 1 |
Orange | Mandarin | 2 |
Grape | Concord | 3 |
Pear | Bartlett | 4 |
Peach | Freestone | 5 |
List to be added:
Item | Description | Position |
Grapefruit | Flame | 2 |
Banana | Cavendish | 4 |
Cherry | Bing | 5 |
Items from the add list must fall into the exact position of the master list in order.
Item | Description | Position | Renumbered |
Apple | Granny Smith | 1 | 1 |
Orange | Mandarin | 2 | 2 |
Grapefruit | Flame | 2 | 3 |
Grape | Concord | 3 | 4 |
Pear | Bartlett | 4 | 5 |
Banana | Cavendish | 4 | 6 |
Cherry | Bing | 5 | 7 |
Peach | Freestone | 5 | 8 |
This has be stumped and any assistance would be greatly appreciated. Thank you for your time
-Ian
Hi @Ian_G
Is there a reason that Cherry/Bing is above Peach/Freestone? The other 2 new records go below the existing items so just want to confirm the logic.
Hi Sorry for the delay.
Reason Cherry/Bing is above Peach/Freestone is based on the ordering provided by the Add list. Banana/Cavendish and Cherry Bing need to placed between Pear/Bartlett and Peach/Freestone because they are to be 4 and 5 in the Master list.
Thanks
ian
Sorry I see my error. Master should be:
Item | Description | Position | Renumbered |
Apple | Granny Smith | 1 | 1 |
Grapefruit | Flame | 2 | 2 |
Orange | Mandarin | 2 | 3 |
Grape | Concord | 3 | 4 |
Pear | Bartlett | 4 | 5 |
Banana | Cavendish | 4 | 6 |
Cherry | Bing | 5 | 7 |
Peach | Freestone | 5 | 8 |