Joining 2 files to create model scenarios

Paul_L

Hi there,

I have 2 sets of input files, a base set of locations and then a second file containing a list of potential locations. 

For example: 

Base Set:

LocationRef     Lat         Long

Location1        12.124   -11.454

Location2        15.431   -13.415

etc

Potential Locations:

LocationRef           Lat         Long

PotentialLoc1        12.124   -11.454

PotentialLoc2        15.431   -13.415

I would like to create a set of scenario input files (and ideally be able to loop through them rather than creating a set of files and reading them back in) that include all the base locations plus each of the potential locations one at a time i.e.

Scenario File 1:

LocationRef          Lat         Long

Location1              12.124   -11.454

Location2              15.431   -13.415

PotentialLoc1        12.124   -11.454

Scenario File 2:

LocationRef            Lat         Long

Location1               12.124   -11.454

Location2               15.431   -13.415

PotentialLoc2         15.431   -13.415

I get the feeling this should be simple (as I could do it in VBA in minutes), but I'm struggling to do this in Alteryx so that I can build it in to a workflow.

Many thanks,

Paul

AdamR_AYX

Try this one

BatchExampleParent.yxzp