ASCIIOUTPUT - Columns Headings

Post Reply
chewza
Posts: 147
Joined: Tue Aug 17, 2010 11:51 am
OLAP Product: TM1
Version: 9.5
Excel Version: 7

ASCIIOUTPUT - Columns Headings

Post by chewza »

Hi there

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

Any ideas?

Many thanks

Regards
Chris
User avatar
bihints.com
Posts: 52
Joined: Tue May 20, 2008 8:56 am
OLAP Product: TM1
Version: 9.0.3
Excel Version: 2003
Contact:

Re: ASCIIOUTPUT - Columns Headings

Post 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;
chewza
Posts: 147
Joined: Tue Aug 17, 2010 11:51 am
OLAP Product: TM1
Version: 9.5
Excel Version: 7

Re: ASCIIOUTPUT - Columns Headings

Post by chewza »

Brilliant - thanks very much!!
tryinghard
Posts: 60
Joined: Wed Aug 04, 2010 3:59 pm
OLAP Product: TM1
Version: 9.5.1
Excel Version: 2007

Re: ASCIIOUTPUT - Columns Headings

Post 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.
User avatar
Alan Kirk
Site Admin
Posts: 6606
Joined: Sun May 11, 2008 2:30 am
OLAP Product: TM1
Version: PA2.0.9.18 Classic NO PAW!
Excel Version: 2013 and Office 365
Location: Sydney, Australia
Contact:

Re: ASCIIOUTPUT - Columns Headings

Post 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.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
Post Reply