Import excel file with date in the file name

saachitalwar

I need import input files in the form ABC_20240603_3m, ABC_20240603_6m, ABC_20240603_9m

This is a regular activity. I tried the * method like *ABC_3m* but it didn't work.

How can I take input for the 3,6,9 month data while ignoring the date in the center.

Raj

@saachitalwar 
The question mark "?" in Alteryx matches exactly one character. Since the date in your file names is always 8 characters long, you can use eight question marks to match the date part.

ABC_????????_?m
you can try this as well.