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 !

Polls
We’re dying to get your help in determining what the new profile picture frame should be this Halloween. Cast your vote and help us haunt the Community with the best spooky character.
Don’t ghost us—pick your favorite now!
Labels