Appending company names to opportunity names for a dummy dataset

[jfha97]

Hello Alteryx Ninjas,

I am trying to create a dummy dataset that has unique opportunities tied to multiple company names. I have randomized both sides of the dataset (side 1 = opportunity name; side 2 = company names), but I am having difficulty tying multiple company names to a unique company name. You can see my workflow for reference attached to this post. 

This is a sample of my data:

Opportunity Names:

NameA

NameB

NameC

NameD

NameE

NameF

NameG

Company Names:

A Capital

B Trust

C LLC

The challenge is that the opportunities list is larger than the company list, so when I append both sides it gives me several opportunities per company. The end result will be a horizontal join, similar to a join tool - and the company names can be randomized (as in no specific order as long as there are multiple banks per a unique opportunity)

End Result:

NameA	A Capital
NameB	C LLC
NameC	B Trust
NameD	A Capital
NameE	C LLC
NameF	A Capital
NameG	B Trust

I would appreciate any guidance or insights, and thank you in advance for your help.

Jfha97

[FinnCharlton · Accepted solution]

Hi @jfha97 , I would use random integers and a join tool:

[jfha97]

@FinnCharlton , thank you! Though not entirely random, it did work. I appreciate your help.