TM1 Forum

I have one ASCIIOUTPUT under the prolog tab and as soon as TI excutes asciioutout is overwriting the file.BUT i want it is once TI excutes i have to add the new data into the existed txt file.is it possible? If possible how

svchowdary83 wrote:I have one ASCIIOUTPUT under the prolog tab and as soon as TI excutes asciioutout is overwriting the file.BUT i want it is once TI excutes i have to add the new data into the existed txt file.is it possible? If possible how

This is a not uncommon request, since it's a function which would actually be useful. However IBM is too busy building unwieldily, monolithic Java applications with pretty chrome trimmings to concern itself with such mundane pursuits. The easiest way to achieve this is the method mentioned in Mike Cowie's post in this thread.

The method I use to do this is to move the actual ASCIIOUTPUT statement you have in the Prolog tab into the Data tab, add a variable counter, and then encapsulate that single statement inside an IF that only executes for the first record. You can still leave all the code that generates the output in the Prolog, just actually write the result in Data. Like this:

Prolog Data