Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Find the properties of files resided in various directories

hamdylie
7 - Meteor

Given a list of files with fullpath details like below, how can I find the file properties, e.g. creation datetime, last mod datetime, file size?

c:\work\dm\274\a.xlsx

d:\cache\b.yxdb

e:\logs\apache.log

f:\input\b.csv 

...

 

The list can change.

 

Thanks.

3 REPLIES 3
hamdylie
7 - Meteor

Just realized that I could do this (not elegant) as follow:

1. Construct and run a batch command to copy the files to a particular directory

2, Configure a Directory Tool to that particular directory

3. Join the Directory Tool output with files list to get the file attributes.

RodL
Alteryx Alumni (Retired)

Try the attached and see if it works for you.

 

It basically determines each directory name for a given file location, runs it through a batch macro process that provides all of the files in that directory, but then only joins to the given file name and returns that.

 

No need for the process to copy a bunch of files somewhere. Smiley Wink

hamdylie
7 - Meteor

Hi RodL,

 

I like your solution better. It's much more elegant and simpler.

 

Thanks.

Labels