Full left Join
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Solved! Go to Solution.
- Labels:
- Join
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
