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
Solved! Go to Solution.
Hi @jfha97 , I would use random integers and a join tool:
@FinnCharlton , thank you! Though not entirely random, it did work. I appreciate your help.