Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Dev Space

Customize and extend the power of Alteryx with SDKs, APIs, custom tools, and more.
SOLVED

Regex

AS
8 - Asteroid

Hi Experts,

 

Hope you all are doing great.

I need your help picking the multiple files but the only condition is if there is a file exist multiple time with the same name then I need to select the oldest file. I'm also thinking may be we can do this by using regex but could not figure it out how.

 

Example-

 

F_000AAA_20220118T001157180_DA.xlsx

1. F_000AAA- Name of the file

2. (Attaching image to explain second part)

3. DA is fixed.

 

NameDecision
F_000AAA_20220118T001157180_DA.xlsxApproved
F_000BBB_20210310T093555697_DA.xlsxApproved
F_000BBB_20210311T163054897_DA.xlsxNA
F_000BBB_20210311T163656587_DA.xlsxNA
F_000CCC_20210715T140732173_DA.xlsxNA
F_000CCC_20210715T030452473_DA.xlsxApproved
F_000DDD_20210715T030452473_DA.xlsxApproved
2 REPLIES 2
atcodedog05
22 - Nova
22 - Nova

Hi @AS 

 

Here is how you can do it.

Workflow:

atcodedog05_0-1643094906459.png

 

Hope this helps : )

 

atcodedog05
22 - Nova
22 - Nova

Happy to help : ) @AS 

Cheers and have a nice day!