Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
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