Connect to previous week file

Hi,

I'm looking for some help with the below and wanted to know if it's doable in Alteryx

I have two input files where one runs daily and the data is refreshed. The other input file I need to connect to a spreadsheet which runs weekly. But the problem is there is a list of files that will run weekly and files will be saved in a folder and I need to connect it to the previous week file from those list of files. Not sure if this is something that can be done via Alteryx so wanted to see if I can get some help here. Thank you!

Input

Accepted answers

All comments

Amol_Telore

Hey @aparna0208

Yes. It is possible. Could you please share file naming pattern so that I can help you with this.

aparna0208

@Amol_Telore Awesome:)

SF_Firms_New_Contacts is the filename.

sparksun

Is it what you need?

aparna0208

Thank you for your inputs:) @sparksun So here is my requirement.

I have a workflow that would use two input data tools. I'll connect an excel file to one of those input tool and add some steps and final output will be written to an excel file. Now I need to take that output file and use it as an input in this same workflow. I know I can schedule the first workflow to run first where it writes the output to an excel and then use that output file as input in the second workflow and schedule that to run after the first workflow is done. But just thinking if it's possible to do it all in the same workflow where after the first part has finished running and then take that output and use it as input for the second part

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703