TM1 Forum

hi,

I'm running 8.4.2 and Excel 2003

i have to load the data from a series of txt files where i will know the opening batch number and the closing batch number but the numbers will not be complete - some relate to a different company that i don't want to load - they won't be in the folder so won't get in the way

i have set up my process in TI to load the first file but now need to have them all load

I think that i need a WHILE loop to load each file in turn. There is a slight complication that the batch file is split in two, some common info in both taht allows me to create attributes in a dimension that allows the load of the data from the second file. I could load all the attributes from the on file type first in process 1 and then all the data files in process2

I'm not clear how i get the counter in the WHILE statement to not fall over when a batch is missing

any suggestions gratefully received

D

You can't process multiple data sources in a single TI process. Only one source per TI because there is no TI function for "opening" a file. That function is built into TI. A WHILE loop wouldn't do you any good because there is no way to open the next source. You CAN link TI's together by calling them from each other but I'm not a big fan of that. Just link them together with a chore if you have to.

Have a "master" TI Process with your WHILE loop. Cycle from start batch number to end (taking into account anomalies where possible) and for each file use the "EXECUTEPROCESS" function to launch your "slave" process and add the filename as a parameter to that "slave" process. Use the Global Variables in your "Slave" TI to set the datasource to the given file. Should work like a charm if your data files are systematic enough.

If you don't know the precise names of your files, but you want to load all files in a directory you can use WildcardFileSearch as the basis of your While loop.

thanks for the advice - I'll test it out tomorrow when I'm back at that client