Hitachi Vantara Pentaho Community Forums

Search Forums:

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

Search Forums: Search took 0.02 seconds.

  1. Thanks a lot. That was the solution!

    Thanks a lot. That was the solution!
  2. Doubt with Calculator Step in Kettle.

    Hi there

    I've got this flow:

    19033

    What I want to do is to copy a column from the lookup step (City Code to Location). However the result is strange:

    19034
  3. Problem with “Create a copy or Field” in Kettle - Pentaho

    I'm facing this strange result with pentaho and a "Calculator" step. I've got this flow.

    19031

    I need to copy one of the column coming from the 'Setting - Location' input step. So I use a...
  4. Replies
    1
    Views
    1,749

    Problem with mysql connection

    Hi there


    Recently I have changed to Pentaho 6.1. I also downloaded the newest .jar file for this database. Unfortunately this connection does not work, but there is somethin strange. When I...
  5. Replies
    0
    Views
    509

    Partitioning problem

    Hi there

    I don't know what I am doing wrong. I want to create a partition. This is my ELT configuration:

    16378

    But I cannot see the name of the partition schema I have created.
  6. Replies
    2
    Views
    1,177

    output fields problem

    I am trying to get the name of the Excel file I am using. This value should be present in the "short filename" field the "Get File Names Step" provides.

    16351


    After extracting the data from...
  7. Problems when processing a set of Excel Files

    Hi there


    I've got this problem with my ETL. The image shows my configuration:

    16345


    From T1 after populate the output table, I have to save the last incremental value this table has.
    In...
  8. Replies
    2
    Views
    833

    Thank you for your reply. I did not know how to...

    Thank you for your reply. I did not know how to make reference to input columns in the formula expression, I was used to see expression like ${variable}, but after look for a solution (thanks to your...
  9. Replies
    2
    Views
    833

    Concatenate fixed values to several columns

    Hi there


    I need to do this. I am getting several columns that I need to modified like this:

    Prefix+Column_Calue+Suffix


    The values for Prefix and Suffix are always the same for all the...
  10. Replies
    4
    Views
    2,829

    I have fixed it. It was an issue with some of the...

    I have fixed it. It was an issue with some of the values used as a parameters
  11. Replies
    4
    Views
    2,829

    I have checked. The SP works fine, it takes an...

    I have checked. The SP works fine, it takes an Input value, and gives me an Output value. In case there is not any data in that table, the SP returns 0 and not null . The tabla A at the end of the...
  12. Replies
    4
    Views
    2,829

    Problem calling a stored procedure in Pentaho

    Hi there


    I have the next questions. The last part of my ETL is this one:


    16291


    So, first: When I am trying to finish de process, after the "Process File" step, I am able to see the...
  13. So far the forum has been very useful for me. I...

    So far the forum has been very useful for me. I just hope you do not get tired of answer my questions :)
  14. Thanks a lot. I am new with Pentaho and...

    Thanks a lot.

    I am new with Pentaho and sometimes I am confused about the use of variables and specially parameters. I thought I was necessary to declare the parameter before to use it within the...
  15. Calling a SP in Pentaho with IN and OUT parameters

    Hi there


    I wonder why I am getting this result from pentaho.
    I am calling a stored procedure that has two parameters: IN and OUT as you can see in the image.

    16279


    But when I am...
  16. Replies
    5
    Views
    1,781

    OK, let me try to explain. suppose the file...

    OK, let me try to explain.

    suppose the file has this configuration:
    id,name,address,observation (this is the header)
    "1,"a","street 1","new address"
    "2,"a","street 1","new "location" abroad"
    ...
  17. Replies
    5
    Views
    1,781

    Hi The thing is. I am reading a csv file...

    Hi


    The thing is. I am reading a csv file that needs to be changed. I am receiving this file with some errors from the source and I can not nothing regarding this, and I need to check line by...
  18. Replies
    0
    Views
    1,583

    Crear un archivo desde Pentaho

    Hola a todos

    Soy nuevo usando Pentaho, anteriormente trabajaba con SSIS. He estado tratando de crear un file desde pentaho usando el paso Defined Java Class.

    Este es el código que he usado...
  19. Replies
    5
    Views
    1,781

    Create a new file using Defined Java Class

    Hi there

    I am new in Pentaho, moving from SSIS and I wonder why I can not create a new file from pentaho using the Define Java Class step. I have tested the next code and it works. But when I try...
Results 1 to 19 of 19
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

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