Adding column with new data

Question

Hi, I have two lists of data, UPC and a store list. I want to blend the data so I have one table with a line for each UPC/store. I can't use join because the lists don't have a common column. I feel like I am missing something really easy here... but banging my head against the wall trying to figure it out.

UPC_Store_combine.yxmd

MarqueeCrew · Accepted Answer

@phoebe_kelley,

Try this:  Switch JOIN to APPEND FIELDS tool.

If you have too many Stores, switch the configuration WARNING (at the bottom of the Append Fields configuration panel) to Allow ALL Appends.

You'll get your combinations.

Cheers,

Mark

Claje · Accepted Answer

EDIT: Beaten by @MarqueeCrew!  His answer is basically the same.

Hi,

The Append Fields tool will do exactly what you're looking for here.

One thing to be aware of is that if you have a ton of records in BOTH sets you could run into an issue where you balloon your dataset, however its pretty simple multiplication to figure out how many of those there are (Records in input 1 * Records in input 2).