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 are there any other files in that folder?

[binuacs]

@saachitalwar try ABC*_*m.xlsx

[Raj · Accepted solution]

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

[saachitalwar]

this worked, thanks!