Alteryx Designer Desktop Discussions

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

1 - Many Relationships

suby
11 - Bolide

Hi All,

 

I have two Data set

 

M- INPUT

Here i have one M_ID with Multiple R_ID

 

R- INPUT

Here i have one R_ID with Multiple M_ID

 

I want to combine this together both the data set and come up with a New column and say-

 

How Many M1_ID's has got how many R1_IDs and
How Many R1_ID's has got how many M1_IDs.

 

I want one output Data set with all the records from M-INPUT and R- INPUT

 

Attached the Sample Workflow.

Thanks

1 REPLY 1
Emmanuel_G
13 - Pulsar

Hi @suby ,

 

Can you please provide for this input an example of excepted output ?

Labels