Record insert from two sources in order

Question

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:

ItemDescriptionPositionAppleGranny Smith1OrangeMandarin2GrapeConcord3PearBartlett4PeachFreestone5

List to be added:

ItemDescriptionPositionGrapefruitFlame2BananaCavendish4CherryBing 5

Items from the add list must fall into the exact position of the master list in order.

ItemDescriptionPositionRenumberedAppleGranny Smith11OrangeMandarin22GrapefruitFlame23GrapeConcord34PearBartlett45BananaCavendish46Cherry Bing57PeachFreestone58

This has be stumped and any assistance would be greatly appreciated.  Thank you for your time

-Ian

Ian_G · Answer

Sorry I see my error.  Master should be:

ItemDescriptionPositionRenumberedAppleGranny Smith11GrapefruitFlame22OrangeMandarin23GrapeConcord34PearBartlett45BananaCavendish46Cherry Bing57PeachFreestone58

Ian_G · Answer

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

mceleavey · Answer

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.

solution_mceleavey.yxmd