Is there a way to get information of our input (ex: modification time, size, etc.)

[Krasus]

Hello there,

A little question for solving my big problem, is there a way to get the modification time and size of my file in Alteryx? Like this:

A great thanks to you and Alteryx Community!!

Shengdu

[MarqueeCrew · Accepted solution]

@Krasus

Yes!

Use the "Directory" tool:

It will ask you for the Directory that you are searching, along with the file specification (e.g. *.xlsx).

The output includes:

Name	Type	Size	Source	Description
FullPath	V_WString	32767	Directory:	
Directory	V_WString	32767	Directory:	
FileName	V_WString	260	Directory:	
ShortFileName	V_WString	14	Directory:	
CreationTime	DateTime	19	Directory:	
LastAccessTime	DateTime	19	Directory:	
LastWriteTime	DateTime	19	Directory:	
Size	Int64	8	Directory:	
AttributeArchive	Bool	1	Directory:	
AttributeCompressed	Bool	1	Directory:	
AttributeEncrypted	Bool	1	Directory:	
AttributeHidden	Bool	1	Directory:	
AttributeNormal	Bool	1	Directory:	
AttributeOffline	Bool	1	Directory:	
AttributeReadonly	Bool	1	Directory:	
AttributeReparsePoint	Bool	1	Directory:	
AttributeSparseFile	Bool	1	Directory:	
AttributeSystem	Bool	1	Directory:	
AttributeTemporary	Bool	1	Directory:	

Everything that you could want!

Cheers,

Mark

[RodL]

Not sure how your workflow is set up, but a couple of ideas...

• You could "Output File Name as Field", set to Full Path, and then take a Summarize tool to get it back to one record, and then Join to the output of a Directory tool that would give you all of the metadata for that one file.
• Or you could start with the Directory tool, filter on the one file you are wanting, and then feed that through a Dynamic Input. But this way you would still have the metadata for the file.

Maybe this can start you down a good solution...

[Krasus]

I have used this brilliant tool but i forget!! Thank you for bringing back my memory!

[Krasus]

I love ur complement and i gonna use your talent to creat my workflow! 

I think it is not the first time you give me the answer i want, thanks a lot.