Translate MS access schema in to Alteryx

[pri_GIS]

Hi,

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

[Ar13f]

Dear @pri_GIS 

you can use the "Join" function as shown below

[pri_GIS]

Hi @Ar13f 

How to specifically use highlighted queries in join tool?

[Ar13f]

dear @pri_GIS 

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

[pri_GIS]

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

[pri_GIS]

I think I am looking for full outer join and union

[Ar13f]

Dear @pri_GIS 

Happy to help  

Cheers and have a nice day!