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

Alteryx designer Discussions

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

Full left Join

Highlighted

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

 

 

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)

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

 

Quasar

@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. 

 

 

 

Attached in '11.3' format

Labels