Detecting the correct input file when file names change

Hello,

I have a workflow where ideally the user places two input files into one folder, with each file following the naming convention of R00846_WMMYYAM.txt with "MM" being the month and "YY" the year . One of the inputs represents data for the prior period (e.g. R00846_0723AM.txt) and the other for the current period (e.g. R00846_0823AM.txt). In Alteryx, I have an input tool for each (prior period and current period). Is there a way to have Alteryx work off the MMYY value in order to determine which file to associate with which input?

Thanks.

Data Investigation

Accepted answers

binu_acs

@Jake5 Use the directory tool read all the input files and filter out the file names which dont fall on last month

Prev_Month_070923.yxmd

All comments

binu_acs

@Jake5 Use the directory tool read all the input files and filter out the file names which dont fall on last month

Prev_Month_070923.yxmd

rzdodson

@Jake5 definitely a couple of ways to tackle this one. Assuming the nomenclature is always the same for the file names and are saved in sequence (re: current file, previous period, 2x previous periods ago, etc.), you can have a Directory tool bring in the file names, grab the two most recent files, and then bring in that data to separate streams entirely.

Inside the macro

Settings change.png

Completed Workflow.yxzp

akvsachin

Hey @binu_acs
Can we do this while using FileBrowse & Action Tools ?

binu_acs

@akvsachinyes, you need to connect with folder Browser tool then connect with action tool

Quick Links

This months top contributors

AkimasaKajitani 389

mceleavey 388

mbarone 337

Hollingsworth 335

LanisC 335