Record insert from two sources in order

[Ian_G]

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

[Luke_C]

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.

[mceleavey]

Hi @Ian_G ,

I added an input number and gave the secondary number 2 as opposed to primary of 1.

As @Luke_C  pointed out, your logic didn't seem consistent but I assumed you wanted the second input to be second to the first (that made sense in my head).

M.

[Ian_G]

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

[Ian_G]

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