Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: How to insert a constant at the start of a text output

  1. #1
    Join Date
    Jun 2009
    Posts
    23

    Default How to insert a constant at the start of a text output

    Hi All,

    How to insert a constant line at the start of a text file output. Or Alternately can I get a customized line in the header instead of column names.
    eg.

    "This is the beginning of results file"
    ----
    ----
    ----
    Footer

    Thanks,

  2. #2
    pstoellberger Guest

    Default

    you could create a text file with the header lines you want and take that as "template" for text file output and always append the content after that header lines

  3. #3
    Join Date
    Nov 2009
    Posts
    1

    Default How to append text

    Hi All,

    I need to add three line of text to a text file before the database fields. Can someone explain in more detail how to use a template to realize that. I do not understand how to append a text file after the header lines as describe. I only see a append checkbox in the text output step.

    Thank you for your help!

  4. #4
    Join Date
    Feb 2009
    Posts
    321

    Default

    hi.. if you need constants I suggest two transformation

    1st: generate rows -->add constants --> text file output
    (here put the contansts lines)

    2nd: table input --> select values --> text file output (with option append)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.