community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE

Help with Join in Designer

Asteroid

Here's what I'm hoping to do.  

 

Contacts (inner join) Case Participation on Contact ID
Case Participation (left join) Bed Night Log on Case Participation ID

and Case (outer join) on Case Participation  on Case ID

 

These are all tables in the same Salesforce DB.  

join.JPG

I'm new to Alteryx, so any help and direction will be welcomed!!!!

 

Please, and thanks for taking a look!

 

Paul

Hi

You can use join transformation.
L is left only, J is inner, R is right only.
So oracle kind of left outer join is L union J. Full outer is L union J union R. Hope it should set you in right direction.
Asteroid

Thanks Rohit, 

 

Would you be willing to show me what that looks like?  I'm not familiar with transformation.

Hi Paul,

 

Unfortunately I am not having Alteryx License anymore.

Please see if below link helps you ...

https://community.alteryx.com/t5/Data-Preparation-Blending/JOIN-Tool-How-to-get-left-outer-join-for-...

Asteroid

Thanks Rohit. 

 

I spent some time familiarizing myself with Alteryx.  I'm set.  Exciting toolset.

Good to know that Paul.

 

Thanks,

Rohit Bajaj

Labels