Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

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

SQL automation in Alteryx.

Ramyasri_1997
7 - Meteor

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. 

6 REPLIES 6
AndrewSu
Alteryx Alumni (Retired)

@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
7 - Meteor
ok Thanks, follow on question: can i make this as a workflow and automate this since i will be using this more frequntly..
AndrewSu
Alteryx Alumni (Retired)

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

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

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

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. 

Labels
Top Solution Authors