TM1 Forum

Hi All,

I am having 3-4 .csv as source files and want to load all of them into a single cube using single TI process(without merging as single flat file)
Is it possible?

Regards,
DP

I am afraid,You can't do it within one TI unless it is master TI calling other processes by ExecuteProcess have it as chore,Please see below post:
http://www.tm1forum.com/viewtopic.php?f=3&t=5984
http://www.tm1forum.com/viewtopic.php?f=3&t=8381 Thanks

As long as the files are in the same format you can use the same TI to load them; just use the datasource functions to specify which file to use at run time.

You can either use a master process that passes the file name each time or call the process itself from its own epilog just passing the "next" file name; if all files have the same prefix you ca use the wildcard search function in the given folder to just keep finding the next one until you've got them all.

Edit - remember if there is a zero out etc you may want to wrap it in an if statement so it only zeros on the first run.

Thanks for the quick response Bari
Regards, DP

Thanks Declan.

Regards, DP