We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
fireworks
SOLVED

Dummy Data from Reference tables

tjamal1
8 - Asteroid

Hello

 

I want create dummy data from my tables 

 

OFFFER table has Offers 

Offer_ID

 

MEMBER Has 

Member_ID 

 

I want create a new table 

which contains these types of  records

MemberID from MEMBER Table

OFFER_ID  from OFFER Table 

 

Sample Table

MEMBEROFFERID
15
16
17
18
21
22

 

Rules : OfferID cannot be repeated within one Member and Each Member should at least have 2 Offers

 

4 REPLIES 4
vizAlter
12 - Quasar

Hi @tjamal1  — Hope this answers your query:

vizAlter_0-1600179272227.png

 

 

If it resolves your query please mark it "Solved" or "Solved" with a Like. This will help other users find the same answer/resolution.  Thank you.

tjamal1
8 - Asteroid

Thanks for the workflow.

Can we create Offers for each customer between =>2 and   <=10

 

Because current workflow gives me only 2 offers for all customers.

vizAlter
12 - Quasar

@tjamal1 — I tried as per your original ask. Now, try this one attached.

 

If it resolves your query please mark it "Solved" or "Solved" with a Like. This will help other users find the same answer/resolution.  Thank you.

tjamal1
8 - Asteroid

Thank you and have a Good Day !

Labels
Top Solution Authors