Right now, the power to solve new global challenges across industries, is at your fingertips, no matter where you're working from. Create a new topic or reply to an existing thread to share your perspective.
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.
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.
In this scenario, you can either look to replicate that functionality directly with the Alteryx Tools, which the above guide can help with. Most likely along the lines of filtering data across the different tables you've mentioned.