Depending on your business process, you may need to load similar data from multiple files. One such example is loading headcount from different HR systems. This may be necessary if your company has gone through a merger. Another example is if you have forecast data coming from several managers in operations that don’t have access to IBM Planning Analytics. Instead of manually combining the files, you can use the WildcardFileSearch TurboIntegrator function to easily loop through all of the files.
The WildcardFileSearch function allows TurboIntegrator processes to search for files within a folder. WildcardFileSearch requires 2 parameters: Path and PriorFileName. The Path can include ‘?’ and ‘*’ as wildcard characters. The ‘?’ is the wildcard for 1 character while ‘*’ is the wildcard for one or more characters. The PriorFileName tells the function were to begin the search. If this parameter is blank, the search begins with the first file in the Path. Below is an example of this function:
WILDCARDFILESEARCH( ‘C:\TM1Server\Files\TM1_*.csv’, ‘TM1_20220301.csv’)
In this example, the function will return the first filename that begins with “TM1_” and ends in “.csv” in the “C:\TM1Server\Files\” folder that occurs after the “TM1_20220301.csv” file.
IBM Planning Analytics, powered by TM1, is full of new features and functionality. Need advice? Our team here at Revelwood can help. Contact us for more information at firstname.lastname@example.org. We post new Planning Analytics Tips & Tricks weekly in our Knowledge Center and in newsletters!
Read More IBM Planning Analytics Tips & Tricks:
IBM Planning Analytics Tips & Tricks: Converting an Alias Back to the Element Name in TurboIntegrator
IBM Planning Analytics Tips & Tricks: Updating ODBC Connections for Multiple Processes