2022.1.1.30569 Patch Release Update

The 2022.1.1.30569 Patch/Minor release has been removed from the Download Portal due to a missing signature in some of the included files. This causes the files to not be recognized as valid files provided by Alteryx and might trigger warning messages by some 3rd party programs. If you installed the 2022.1.1.30569 release, we recommend that you reinstall the patch.

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!