SQL automation in Alteryx.

[Ramyasri_1997]

Hi,

I am new to Alteryx. just exploring the amazing features it has. The main reason I started using Alteryx is to automate the regular tasks. Here I have the file attached with the out put file as well in 1 & 2. in regular basis I use SQL to retrieve the data from DB  using joins and where syntax. 

EX 

select column1,column2,column3 from table1 where column1 = 'data' and column2 between oct1 to oct3.

select a.column1,a.column2,a.column3,b.Column1,b.column2,b.column3 from table1 join

table2 on a.column1 = b.column1

where a.column1between jan1 and march31

and a.column2 = Alteryx.

these are the common queries I use in regular basis on larger files and upto 15 times for various scenarios. 

here I would like to automate this process in Alteryx , if possible please assist. your help is much appreciated. Thanks in advance. 

[AndrewSu · Accepted solution]

@Ramyasri_1997 , you can use the SQL syntax you're already using directly within Alteryx if you can connect to the database directly!

See the documentation below. 

https://help.alteryx.com/20221/designer/choose-table-or-specify-query-window 

If this helps you resolve the issue, please mark this post as the solution so that others in the community can benefit from our collaboration. 

Thanks!

[Ramyasri_1997]

ok Thanks, follow on question: can i make this as a workflow and automate this since i will be using this more frequntly..

[AndrewSu]

Hello @Ramyasri_1997 , once you create the workflow you can schedule it to run at set times with Alteryx Server.  

See documentation below.

https://help.alteryx.com/20221/server

Does your organization have Server?

[Ramyasri_1997]

Hi,

Thanks for your Time, Let me check with my ORG IT team, I am sure we should have one. 

QQ) SO every time the source data changes. FOR Ex; this time I use 

select first name,lastname,phonenumber,address,activity_date

from EMP table

where phonenumbers in ('984824','558877','778855','446699',4433221',229955')

and activity_date  between '01-01-2022' and '01-31-22022......

here the Phone numbers In data will be updated with new info. 

[Ramyasri_1997]

Hi,

Thanks for your Time, Let me check with my ORG IT team, I am sure we should have one. 

QQ) SO every time the source data changes. FOR Ex; this time I use 

select first name,lastname,phonenumber,address,activity_date

from EMP table

where phonenumbers in ('984824','558877','778855','446699',4433221',229955')

and activity_date  between '01-01-2022' and '01-31-22022......

here the Phone numbers In data will be updated with new info. 

[Ramyasri_1997]

Hi,

Thanks for your Time, Let me check with my ORG IT team, I am sure we should have one. 

QQ) SO every time the source data changes. FOR Ex; this time I use 

select first name,lastname,phonenumber,address,activity_date

from EMP table

where phonenumbers in ('984824','558877','778855','446699',4433221',229955')

and activity_date  between '01-01-2022' and '01-31-22022......

here the Phone numbers In data will be updated with new info.