Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Full left Join

vinaynaran
5 - Atom

Hi All,

 

I am New to Alteryx Designer  Version 11.3.

 

I am looking for Full left Join in alteryx, Do I have to use Union Tools After Join Tool?

 

I have file1 like...

EmpIDName
1James
2Mark
3Peter
4Alley
5Sam

 

and File2 like...

EmpIDAge
134
245
432
544
728

 

And I want output like...

EmpIDNameAge
1James34
2Mark45
3PeterNull
4Alley32
5Sam44

 

What is the Fasted & easiest way to join this two files?

 

Please help.

Thanks

Vinay

 

 

4 REPLIES 4
jdunkerley79
ACE Emeritus
ACE Emeritus

Two ways I do this:

 

2018-12-06_12-01-36.png

 

1. As you describe join and union

2. Use a Join Mulitple which does full outer and then filter

 

Sample attached doing these ways

 

There are many other ways (e.g. Find and Replace can be used)

vinaynaran
5 - Atom

Hi,

Thanks for your quick reply and suggestion.

 

Your attachment I can't open as you have created in more recent version.

 

I am using version 11.3

 

Thanks a lot.

Vinay

 

Kenda
16 - Nebula
16 - Nebula

@vinaynaran in order to open @jdunkerley79's post, simply right click on the file in your Windows Explorer and select 'Edit with Notepad++'. On the second line, change the version number to match the version you are using (11.3). Save and close the file then try reopening with Alteryx. It should now be able to open successively. 

 

 

 

jdunkerley79
ACE Emeritus
ACE Emeritus

Attached in '11.3' format

Labels