Missed the Q4 Fall Release Product Update? Watch the on-demand webinar for more info on the latest in Designer 24.2, Auto Insights Magic Reports, and more!
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Free Trial

Alteryx Designer Desktop Discussions

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

Translate MS access schema in to Alteryx

pri_GIS
7 - Meteor
‎10-04-2021 05:33 PM

Hi,

How to use join properties in Alteryx for options 1 and 2, as shown in MS Access

gaikwadp_0-1633393964297.pnggaikwadp_1-1633393975743.png

 

Labels:
Reply
6 REPLIES 6
Ar13f
10 - Fireball
‎10-04-2021 05:43 PM

Dear @pri_GIS 

 

you can use the "Join" function as shown below

 

Join 1.png

 

Join 2.png

Reply
0 Likes
pri_GIS
7 - Meteor
‎10-04-2021 05:47 PM

Hi @Ar13f 

How to specifically use highlighted queries in join tool?

Reply
0 Likes
Ar13f
10 - Fireball
‎10-04-2021 05:48 PM

dear @pri_GIS 

 

sorry I forgot to provide the attachment .... I hope this is what you mean.

Solution gaikwadp.yxmd
Reply
0 Likes
pri_GIS
7 - Meteor
‎10-04-2021 05:59 PM

Thanks for reply. I will check and get back to you

Reply
0 Likes
pri_GIS
7 - Meteor
‎10-04-2021 06:32 PM

I think I am looking for full outer join and union

Reply
Ar13f
10 - Fireball
‎10-04-2021 08:45 PM

Dear @pri_GIS 

 

Happy to help  

Cheers and have a nice day!

Reply
0 Likes
register for inspire
designer new user guide
Labels
Top Solution Authors
View All