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

Alteryx designer Discussions

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

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