Generating Data dependent on the corresponding value in another dataset

1

I have sale-transaction dataset that has random values for fields “custid” and “order_number”.

I want to generate another dataset customer_feedback that randomly picks “custid” and corresponding “order_number” from sale-transaction dataset.

Is there a way to achieve this on Mockaroo?
Thanks for the help.

2

Did you try using data set option ?

if not, create a test data for sale-transaction and upload them as dataset.
in the customer feedback schema use dataset option for order_number and custid and select dataset columns of the sale-transaction

3

No, I haven’t tried data set option. I will try it.
thanks for the help

4

Used the data set option. It allows me to pick the columns from the sale-transaction. But how do I make sure that once it picked a value for custid, it get the corresponding value of order_number from that dataset?

5

Sorry, your earlier suggestion worked. I have it working. Thank you for your help