TM1 Function for TI, FileExists

Searches if a file exists in a folder.

What is the FileExists function?

FileExists searches if a file exists in a folder. If the file exists, then 1 is returned, otherwise 0 is returned. 

Where can the FileExists function be used?


What is the syntax for FileExists?


​File = File full name including file extension and path.

A demonstration on how to use …

Use FileExists to check if the file, Product Scorecard.txt and ProductScorecard.txt, exists in a folder.