Adding column with new data

[phoebe_kelley]

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.

[MarqueeCrew · Accepted solution]

@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 solution]

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).

[MarqueeCrew]

@Claje,

Beaten is such a strong word.  How about corroborated?

Perhaps @phoebe_kelley will mark both of our answers as solutions :).  They are the same.

Cheers,

Mark

[phoebe_kelley]

thanks! That worked perfectly!