FileExists function for IBM Planning Analytics (TM1)
FileExists searches if a file exists in a folder. If the file exists, then 1 is returned, otherwise 0 is returned.
In this video, FileExists is used to check if the file, Product Scorecard.txt and ProductScorecard.txt, exists in a folder.
Where can the FileExists function be used?
TurboIntegrator
Which TM1 Server version is the FileExists function available for?
Version 11 and 12
What is the syntax for FileExists?
FileExist(File)
- File = File full name, including file extension and path.
Relevant Functions
- AddInfoCubeRestriction = Filters InfoCube data as it is pulled into TM1. Use this function to restrict the values that are imported for a specified characteristic
- Expand = Expands variable names, enclosed in % signs
- FileExists = Searches if a file exists in a folder. If the file exists, then 1 is returned, otherwise 0 is returned
- LogOutput = Writes a message to the tm1server.log file
- TM1User = Returns the user logged in
- WildcardFileSearch = Searches files using wildcard characters in a folder