Multiple CSV Sources data Load

[DPTM1Guy]

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

[BariAbdul]

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

[declanr]

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.

[DPTM1Guy]

Thanks for the quick response Bari
Regards, DP

[DPTM1Guy]

Thanks Declan.

Regards, DP