Hi there
I would like to specify columns heading to my CSV extract file.
Any ideas?
Many thanks
Regards
Chris
ASCIIOUTPUT - Columns Headings
- 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
set a flag in the prolog, test it, then change its value once you passed your columns headings.
example:
PROLOG TAB:
DATA TAB:
example:
PROLOG TAB:
Code: Select all
header = 1;
Code: Select all
if(header = 1);
asciioutput(file,'my,columns,headings');
header = header - 1;
endif;
Re: ASCIIOUTPUT - Columns Headings
Brilliant - thanks very much!!
-
- Posts: 60
- Joined: Wed Aug 04, 2010 3:59 pm
- OLAP Product: TM1
- Version: 9.5.1
- Excel Version: 2007
Re: ASCIIOUTPUT - Columns Headings
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.
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.
- 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
The headings above the code snippets tell you which tab to put it on. First line of code in the Prolog, reminder in Data.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.
"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.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.