community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Community v19.6

Looks aren't everything... But the latest Community refresh looks darn good!

Learn More

How do we check file exist in a directory or not

Highlighted
Meteoroid

Hi All,

 

I am looking for a tool which tells me whether a file exists in directory or not.

 

I found a tool "Dynamic Select", in that we have a function Called FileExists(Path).

 

I am trying to give something like FileExists("C:\Users\xyz\Desktop\temp.csv"). But I am getting error as "Error: Dynamic Select (8): RecordInfo::CreateRecord:  A record was created with no fields."

 

Please provide solution ASAP.

 

Regards,

Srinivas.

@sdevireddy I would use the FileExists function inside a formula tool to create a field called Flag. Then you could filter on that field.

Meteoroid

Thanks Patrick. That helps.

Asteroid

Hi @sdevireddy,

You could also use a filter tool off of the directory on full path and then count records. Not as clean as patrick's idea but if count is >0 you would know it exists. 

 

Kind regards,

Cameron

 

 

Labels