Import Property Information from a File into Alteryx

Question

Alteryx Designer allows for the inclusion of the file name or full path of a file being imported, such as Excel.  How does one import additional information that can be found by right clicking on the file and selecting properties?  For instance, it would be valuable to be able to have information such as Authors, Last saved by, Content created, Date last saved, etc.  Can this be done?

Drussek · Answer

You may also use Run Command tool and use eg. wmic from Windows.

Take a look at the attached example - you can get full file info.

runCommand_fileInfo.yxmd

NeilFisk · Answer

Gabriel,

Thanks.  I was aware that the Directory tool adds some additional information but was looking to see if additional information was available.  The key item is the last user.  If we're setting up a workflow on the Gallery to allow a user to upload data from a file, it would be valuable to capture the last user of that file.

Garabujo7 · Answer

Hello @NeilFisk ,

You may see that using the directory tool

These are some of the attributes you'll get:

Hope this helps.

Gabriel