Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: Column Value same throughout

  1. #1

    Default Column Value same throughout

    Hi, I'm using PDI 5.2, while consolidating three .CSV files I'm facing a problem i.e there is a common column in all three files but the value is different and when I consolidate it, it shows me the same value throughout...in the file attached below, in output console the column "Exp_Name" consist of same value throughout ,but in source it has different values.....
    the component I had used is TextInputFile--->Add Constant------>Calculator
    please help me with this....
    Attached Files Attached Files

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

    Default

    Since you've only shown us the output, we can only guess as to the cause.
    Pasting images here really isn't all that helpful, because they get resized, and become unreadable.

    Post the actual transform, and we might have more insight.

    My initial guess is that you're adding the Exp_Name in the Add Constant step, which does exactly what it says it does... Adds a constant value.

  3. #3

    Default

    Hey Thanks gutlez for your help, but in Add Constant step I had set only "Substance" & "Nature" column as a constant value , the "Exp_Name" column has different value in each of the files. plz assist ....
    Last edited by deepesh_matkati; 12-03-2015 at 01:09 AM.

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

    Default

    Post your transform, and a sample input file (it doesn't need to be real data, just conforms to the real data requirements)
    There is NOTHING we can do with what you have provided so far.

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.