Page 1 of 1

ASCIIOUTPUT - Columns Headings

Posted: Tue Aug 17, 2010 11:54 am
by chewza
Hi there

I would like to specify columns heading to my CSV extract file.

Any ideas?

Many thanks

Regards
Chris

Re: ASCIIOUTPUT - Columns Headings

Posted: Tue Aug 17, 2010 12:19 pm
by bihints.com
set a flag in the prolog, test it, then change its value once you passed your columns headings.
example:

PROLOG TAB:

Code: Select all

header = 1;
DATA TAB:

Code: Select all

if(header = 1);
    asciioutput(file,'my,columns,headings');
    header = header - 1;
endif;

Re: ASCIIOUTPUT - Columns Headings

Posted: Tue Aug 17, 2010 12:41 pm
by chewza
Brilliant - thanks very much!!

Re: ASCIIOUTPUT - Columns Headings

Posted: Thu Aug 19, 2010 9:39 pm
by tryinghard
Hi,

Can you please share an example of Asciioutput, where do you write this function, in Prolog, or data... I am new to TM1, so sorry for such a dumb question.

Re: ASCIIOUTPUT - Columns Headings

Posted: Thu Aug 19, 2010 10:02 pm
by Alan Kirk
tryinghard wrote: Can you please share an example of Asciioutput, where do you write this function, in Prolog, or data... I am new to TM1, so sorry for such a dumb question.
The headings above the code snippets tell you which tab to put it on. First line of code in the Prolog, reminder in Data.