Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Check out our powerful new search update! You can read more here. Please let us know if you have any feedback by creating a topic here.

How to identify different date format in a file name

Highlighted
Atom

Hi,

 

I have different files which have same data set, but i need to remove duplicate files based on the date in file name. As you can see from the image, file name is not consistent but each file has a date mentioned in different format. Can some one please share their expertise to identify, modify and remove the duplicates? Thank you in advance.

Highlighted
Asteroid

You could use the Directory Input tool, and the Unique tool to filter out where the Creation Date and File Size are the same.

 

See the recap of @Balders session, 'TEST, TEST, TEST. HOW TO BUILD ROBUST ALTERYX WORKFLOWS', it's exactly what he covers.

https://www.alteryx.com/inspire-emea-2019/inspire-europe-2019-attendee-recap

Labels