Full left Join

[vinaynaran]

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

EmpID	Name
1	James
2	Mark
3	Peter
4	Alley
5	Sam

and File2 like...

EmpID	Age
1	34
2	45
4	32
5	44
7	28

And I want output like...

EmpID	Name	Age
1	James	34
2	Mark	45
3	Peter	Null
4	Alley	32
5	Sam	44

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

Please help.

Thanks

Vinay

[jdunkerley79 · Accepted solution]

Two ways I do this:

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]

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 · Accepted solution]

@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 · Accepted solution]

Attached in '11.3' format