Data into Final CSV file

[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

[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).