Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Getting CSV file name

  1. #1
    Join Date
    Feb 2016
    Posts
    22

    Smile Getting CSV file name

    Hi Team,

    I am using "CSV file input" to load data from my csv file. I need to populate csv file name in one field of my target table. Tried "Add filename to result" also but it could get the file name. I think it should be very common need, so tried searching also but could not get anything. Can you please help me in this regard.

    Regards.. Jawed

  2. #2
    Join Date
    Apr 2008
    Posts
    4,696

    Default

    "Add filename to result" does exactly what it says it does. (Think similar to the "Copy row to result step")
    What you are looking to do is add the filename to the data stream, which is something completely different.

    Instead of using the CSV step, use the Text File Input step, which has an option on the "Additional Fields" tab that will allow you to define a column in the stream to hold the filename that the row came from.

  3. #3
    Join Date
    Feb 2016
    Posts
    22

    Default

    Thank you, I am using Text File Input

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.