Full left Join

Question

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

EmpIDName1James2Mark3Peter4Alley5Sam

and File2 like...

EmpIDAge134245432544728

And I want output like...

EmpIDNameAge1James342Mark453PeterNull4Alley325Sam44

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

Please help.

Thanks

Vinay

jdunkerley79 · Accepted Answer

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)

Kenda · Accepted Answer

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

Attached in '11.3' format