Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Creating a file name with a suffix

  1. #1
    Join Date
    Sep 2010
    Posts
    6

    Default Creating a file name with a suffix

    I am trying to creae a file name that has a suffix prior to the extension where the formate will be:

    CompanyID_TransactionType_yyyy-mm-dd_Suffix.csv

    I have the file creation correct up untial I get to the "_Suffix" and I'm creating a file with the format:

    CompanyID_TransactionType_yyyy-mm-dd.csv

    How can I add the suffix portion of the file name?

    Thanks in advance.

  2. #2
    Join Date
    Apr 2008
    Posts
    1,771

    Default

    How do you create your file?
    If you use the Text output step you can create a variable and then add the variable in the filename:
    CompanyID_TransactionType_yyyy-mm-dd_${Variable_Suffix}.csv

    Mick

  3. #3
    Join Date
    Aug 2011
    Posts
    15

    Default

    Hi,

    Is your suffix name is standard,
    if it's standard you can set 'Environment Variable' after date format.

    eg: ${suffix_name}



    Regards
    Ashwin Ganesh.R

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.