Skip to Content
0
Former Member
May 12, 2010 at 07:48 PM

Load data fil with multiple account columns

153 Views

Hi everyone

I have to load a data file with multiple account columns, just like in this example:

Time;Category;Entity; account1;account2

2009.JAN;ACTUAL;ENT1;100;120

How can I do it with a transformation file? I have tried the fcol() function but without success,

¿Is there a way to load this kind of file?

Thanks a lot for your help!