Hitachi Vantara Pentaho Community Forums

Search Forums:

Type: Posts; User: bcrow; Keyword(s):

Search Forums: Search took 0.02 seconds.

  1. Replies
    3
    Views
    530

    No I didn't.

    No I didn't.
  2. Replies
    3
    Views
    530

    Question about string lookups in MS-SQL

    I'm reading in a text file and doing a sql lookup on one of the fields that is defined as String.
    I'm trimming the field and it typically has 8-20 characters and defining the length as 255 on the...
  3. the same thing happens with compatibility mode...

    the same thing happens with compatibility mode off, I turned it On just to see if it was a factor.

    the S2F fields are coming from a text file but not with lazy convert,...
  4. you're right, variables mean something different...

    you're right, variables mean something different in PDI.18894 I've uploaded a sample of what I'm talking about. I have a column in my row named mon_remaining defined as BigNumber and initialized to...
  5. Unexpeted Data Type Conversion error javascript and sql server

    I have a transformation where I use the modified javascript step to calculate a couple of integers and a couple of BigNumbers.

    I create them as new variables of the appropriate type and output...
  6. I'm not sure what's happening with the sample,...

    I'm not sure what's happening with the sample, but my problem is resolved. My input field I was passing was an Integer, the field in the sub-transformation I was mapping it to is a string. My...
  7. No, I don't the mappings. I saved it and it...

    No, I don't the mappings.
    I saved it and it changed the mapping step to use my file repository.
    The source and target fields are populated but the mappings column is empty and there's nothing on...
  8. PDI-CE-7 mappings not saving in Mapping (execute sub-transfomation) step

    running pdi-ce-7.0.0.0-25 , windows 10, java 1.8.0_131 , 64 bit on Dell laptop.
    I'm using a file repository on my local hard drive.
    I can enter the mappings, save the step and the transformation....
  9. Replies
    33
    Views
    14,983

    I'm having this same problem, no repository is...

    I'm having this same problem, no repository is showing up, in the Tools>Repository menu all options are grayed out. I've tried using the attached log4j.xml below, no effect.
    In Tools>Options I've ...
  10. Replies
    4
    Views
    1,817

    after getting it loaded using 'explore...

    after getting it loaded using 'explore repository' I was able to create a new version by cutting and pasting into a new transformation. The problem may have been a calculator step where I was making...
  11. Replies
    4
    Views
    1,817

    I'm using java 1.8

    I'm using java 1.8
  12. Replies
    4
    Views
    1,817

    I tried closing down and restarting , loading...

    I tried closing down and restarting , loading from repository and importing the transformation as an xml file, neither worked.

    Finally I shut down, restarted, did not connect to the repository at...
  13. Replies
    4
    Views
    1,817

    Opening a kettle file comes up empty

    using ce 5.4 I've saved a transformation but when I open it , I get no error, no message but nothing loads.

    looking at the .ktr file it looks ok, i.e. all the open tags appear to have closing...
  14. Replies
    2
    Views
    481

    Thanks Mathias, I think that will work. I doubt...

    Thanks Mathias, I think that will work. I doubt I'd have thought of reading the file twice, once for just the header and again for the data (obviously I hadn't) - but that's exactly the kind of...
  15. Replies
    2
    Views
    481

    Using Metadata in a transformation

    I know I can get column/stream names using the Utility > Metadata structure of a stream step.

    Where I'm having a conceptual failure is how I can use that information.

    I want to be able to...
  16. no, I don't seem able to upload a screenshot of...

    no, I don't seem able to upload a screenshot of the error, I get an error when I try to upload an image. (error #2038) after I upload the image.


    this sql works: select first_name,last_name from...
  17. CE 5.3 DatasourceServiceImpl.Error 0009 - using mssql, jre7

    This is a very odd problem. Create New/Datasource

    Using MSSQL 2008, sqljdbc41.jar and jre7 - I can create a new connection and test the connection successfully.

    A Select statement that does...
  18. thanks, I see the difference now. Originally I...

    thanks, I see the difference now.

    Originally I was trying to pass 2000 records from pdi to prd and had all my aggregation in prd groups.

    I moved the aggregation to the transformation using the...
  19. no, it's 1 report on 2000 records. and takes 10...

    no, it's 1 report on 2000 records. and takes 10 minutes to produce
  20. Yes, this makes perfect sense and is how I have...

    Yes, this makes perfect sense and is how I have my transformation configured. But the passing of each row to the Pentaho Reporting Output step is crawling at 2 or 3 records per second in the step...
  21. I want to create the report(s) whenever the...

    I want to create the report(s) whenever the transformation runs using report definitions from prd.

    I've discovered that if I leave out the Pentaho Reporting File Output step of my transformation...
  22. I'm still having very poor performance running a...

    I'm still having very poor performance running a report from PDI using the Pentaho Reporting Output step. I've tried with both PDI 5.0.1 and PDI 5.1 and both are passing records to the reporting...
  23. I figured this out, I think. My transformation...

    I figured this out, I think. My transformation was using a pentaho reporting output step and my report was using that transformation as the datasource.

    I created a new transformation that did...
  24. Problem with CE PRD 5.0.1-stable and PDI 5.0.1-stable

    I have a simple transformation that reads a 1000 record file, selects a column , sorts it and then goes to a Pentaho Reporting output

    When I execute this transformation in spoon, it hangs on the...
  25. Help - using data grid to control iteration over columns in a rowset

    Hello I'm trying to set up Kettle so that it can be easily configured for multiple jobs that are similar. For example, we get an input file to load onto our database that will consist of thousands...
Results 1 to 25 of 25
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

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