Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Get data to CSV from multiple tables from Server one by one

Arvi_Singh
6 - Meteoroid

Hi All,

 

Scenario - Everyday a new SQL table is created on  Google Big Query, with the same name but with the latest date stamp. Ex APP_DATA_200180415, APP_DATA_200180416, APP_DATA_200180417 etc. I need to fetch data from the recently created table on a daily basis. I can get the data from individual table by using an input tool. But here i want to automate the process so that the i get the data from the recently create table on a daily basis.

Can someone please suggest what is the best way to implement this process.

 

My Thoughts

I thought of creating a batch macro to pass the latest table name along with TimeStamp everyday but this is not working. Not sure if can dynamically pass the table name to an input tool in macro and get the table data. 

 

Also, Is there a way where i can get data from all the tables from server using the input tool. 

 

Thanks in Advance,

Arvind 

2 REPLIES 2
LordNeilLord
15 - Aurora

Hey @Arvi_Singh

 

You need to have a look a look at the Dynamic Input Tool

 

You can use this tool to modify the SQL statement and pull the daily tables that you require

 

For you second point, I think Dynamic Input would suit your needs as well

 

@LordNeilLord

Part time Tableau, Part Time Alteryx. Full Time Awesome


Data Lover

Arvi_Singh
6 - Meteoroid

Thanks a ton @LordNeilLord ! This helped. 

Labels