Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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