How to get the last modified person name of excel workbook in the Alteryx designer

[npeddagorla]

I have an usecase where i need to know the person who modified the excel workbook in the shared folder. Using a directory tool i am able to get the last modified time not the person who modified. 

[leehaozhong · Accepted solution]

You can use the Command prompt function with dir /q. The function will show you the owner of the file which is actually the last modified person.

I have referred to https://community.alteryx.com/t5/Alteryx-Designer-Discussions/How-to-get-results-of-DIR-command-into... post by Alteryx guru @jdunkerley79 and bastardize the workflow a bit.

 Please see workflow attached and try to connect to your existing workflow.

I have also attached the screenshots what I have changed.

[Amadeu_gustavo]

@leehaozhong 

I'm spouse to do this with many different directories.

I've made this batch macro based on your content.

But ever run, about the fourth batch, it stops with this error:
"Dir_LastModifiedBy (143) Record #4: Tool #30: File selection does not contain data; select a valid data file."

Can you help me with this? Not sure how this RunCommand tool works...