Page 1 of 1

Data into Final CSV file

Posted: Tue Aug 28, 2012 3:03 pm
by AshokReddy
Hi Team,

I have extracted 3 CSV files from one cube using different views, Now i want to make a final CSV file using these 3 files using TI process.

how can i achive this in TM1.

Regards
Ashok

Re: Data into Final CSV file

Posted: Tue Aug 28, 2012 3:32 pm
by qml
The easiest way is to combine the files using the copy DOS command e.g.:

Code: Select all

ExecuteCommand ('copy file1.csv+file2.csv+file3.csv finalcsv.csv', 1); 
You could also have a single source view instead of 3 and just create one csv to start with (unless really not possible).