In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Set up your security questions now so you can recover your account anytime, just log out and back in to get started. Learn more here
Start Free Trial

Alteryx Designer Desktop Discussions

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

Looking for a process or batch marco

Dhruv_001
7 - Meteor

I have my transformation workflow which generates result.

I am looking for a batch macro which read's the current date file name from the sql tables and last 30 days of data together. Transform the data and save the result. Then my batch macro will read the next file with last 30 days and save the output. I want to repeat this process for two years of data.

1 REPLY 1
binu_acs
21 - Polaris

@Dhruv_001 @What you mean by current date file from SQL table? Why don’t your workflow read all the data and process the transformation and save the output based on the condition?

Labels
Top Solution Authors