Looking for a process or batch marco

Question

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.

binu_acs · Answer

@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?