Hitachi Vantara Pentaho Community Forums

Search Forums:

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

Search Forums: Search took 0.02 seconds.

  1. Replies
    1
    Views
    1,124

    [Get a file using HTTP Step] Bad performance

    Dear,

    I'm using the "get a file using HTTP" step to download a file from a server.

    Unfortunately, performances are not good. Indeed, for a 50 Mo file, Kettle needs more than 3h just to...
  2. I'm still blocked by this problem. I...

    I'm still blocked by this problem.

    I currently use Kettle 2.5.0 GA and the last Kettle.jar version.

    The parameter nb_line isn't passed to the evaluation job entry.
    Is it a bug of the...
  3. Replies
    2
    Views
    4,342

    The function of calculator step, you want to use,...

    The function of calculator step, you want to use, doesn't replace the value (here NULL) of the field A by the value of the field B.

    It affects to a new field the value of B if A is NULL.
    It's...
  4. Replies
    3
    Views
    1,813

    Do you necessarily have to use variables ? If...

    Do you necessarily have to use variables ?

    If not, you can copy the result of your transformation with the "copy rows to result" step and use one of your field passed as parameter for your...
  5. I don't know why my job works for you and not for...

    I don't know why my job works for you and not for me...

    I downloaded the Kettle version and the Kettle.jar from links you gave me yesterday, and it doesn't work.

    Concerning your...
  6. I agree with you Sven, each part works... The...

    I agree with you Sven, each part works...

    The evaluation step works, I already use it in other transformations.
    The SQL step works too, when I preview it.

    But the both doesn't work with my...
  7. Sven, You'll find, joined, un sample of my...

    Sven,

    You'll find, joined, un sample of my transformation.

    When I run it, there isn't error, but the result of the evaluation is not what it should be.

    Perhaps, I did somethings wrong......
  8. Thanks for your help... But it doesn't still work...

    Thanks for your help... But it doesn't still work

    I Installed the GA version of Kettle et replaced the original kettle.jar by the one given via the URL.

    My job is as follow :
    - T1, in which...
  9. I've downloaded, via the Pentaho Data Integration...

    I've downloaded, via the Pentaho Data Integration version 2.5.0 GA thread, 2 versions of PDI (it seems) :

    - the Kettle-2.5.0 version,
    - the Kettle-src-2.5.0 version.

    The first one seems to...
  10. [Execute SQL Script step] How to return the result of a select in a field

    Hi all,

    In one of my transformation, I insert data in a table of my database.
    I would like to know how many rows have been inserted in my table.

    I use the Execute SQL script step given in...
  11. I've solved my problem...

    I've solved my problem...
  12. Replies
    5
    Views
    5,335

    Well, it works ! I only put an first...

    Well, it works !

    I only put an first transformation in my sub-job to get the field in all the sub-job.

    It seems that without this the information isn't pass in the other transformation of the...
  13. Replies
    5
    Views
    5,335

    Hi Samatar, Your idea to loop is good. I...

    Hi Samatar,

    Your idea to loop is good. I tried it yersterday.
    But strangely, it doesn't work.

    I checked, in the sub-job entry the 2 options : "Copy previous to args" and "Execute fo every...
  14. Replies
    5
    Views
    5,335

    Thanks for your example Shassan. However I...

    Thanks for your example Shassan.

    However I would like to evaluate several lines and I don't achieve to do work it.

    I've tried this, but it doesn't work :
    for(var i;i<lines_read;i++)
    var...
  15. Replies
    5
    Views
    5,335

    How does the Evaluating Javascript job entry

    Dear,

    Would it be possible to see an easy example of the functioning of the Evaluating Javascript job entry ?

    I would like to test the value of a field to run an sub-job or an other...

    Is...
  16. To start 2 transformations after only one : Problem of mixture of data

    Dear,

    In one of my job, I run 2 transformations, after the execution of only one transformation (see the the plan below)

    After this, I run a transformation which do aggregates in my data...
  17. That's right, I've done a mistake... It...

    That's right, I've done a mistake...

    It works, but only with the "Modified JavaScript" step.

    But it works ! :-)

    Thanks for your help.

    Regards
    Gambi
  18. Hi, Thanks for your help. I've tried your...

    Hi,

    Thanks for your help. I've tried your solution, but it doesn't work... :-(

    When I run the transformation, I obtain the error :
    " ReferenceError: "str2dat" is not defined (script; line...
  19. To parse String to date according to OS_language

    Dear,

    I have to convert a date from a String type (e.g. 03/May/2007 12:12:12) to a date type. I use a JavaScript step to do this.

    My problem is I work on "french Os" and "english Os", it...
  20. Darius, If you want to replace "\" by "\\" in...

    Darius,

    If you want to replace "\" by "\\" in a field, you can use a "split field" step followed by a "javascript" step, as follows :

    - use a "split field" step with "\" as delimeter. You...
  21. Replies
    4
    Views
    1,425

    Thanks all for your help ! But it seems to...

    Thanks all for your help !

    But it seems to not work with URL adress (my file is download from a servor, via this URL address).

    For information, the filename (URL address) is passed as...
  22. Replies
    4
    Views
    1,425

    Thanks Sven, it seems to be a good idea. I'm...

    Thanks Sven, it seems to be a good idea.
    I'm going to try your solution.

    Nevertheless, could you please tell me (if you know about it) what kind of result works out the "file exists" job entry....
  23. Replies
    4
    Views
    1,425

    Error handling with the "Text File Input" step

    Dear,

    I have a transformation in which files are extracted via the Text File Input step.

    The file name is a http adress, passed as parameter with the "accept filenames from previous steps"...
  24. Insert data in a base using a field as name of database

    Dear,

    I would like to insert data in a database, using a field as name of this base.

    I use the "Table Output" step and one of its options "Is the name of the table defined in a field ?".
    ...
  25. In my case, I use a SQL Script to execute the...

    In my case, I use a SQL Script to execute the aggregates of my database. (formerly done by stored procedures. Sorry for confusion...)

    All works well...

    Here, my problem is that this...
  26. Run a transformation at the end of severals previous transformations

    Dear,

    I use a job that loads data in several databases (a transformation by database to load/update).

    I would like to run a transformation ( which calls Stored Procedures) at the end of all...
  27. Replies
    17
    Views
    2,886

    Yes, you're right ! Many messages for only...

    Yes, you're right !

    Many messages for only one simple change of name...! :eek:

    The next time, I'll send you a use-case.

    Thanks one more time

    Regards,
    Gambi
  28. Replies
    17
    Views
    2,886

    Effectively Sven, It works ! It's a little...

    Effectively Sven, It works !

    It's a little bit strange, but it works...

    Thanks Sven and Matt for your help.

    Regards,
    Gambi
  29. Replies
    17
    Views
    2,886

    I'm not sure to understand you very well... ...

    I'm not sure to understand you very well...

    The field "URL" must be filled to do work the job ?

    Until now, I never filled it, because the URL adress changes according to hte day, for...
  30. Replies
    17
    Views
    2,886

    I've just posted a bug report, but I'm not...

    I've just posted a bug report, but I'm not registered, so I don't know if my post is going to be save...

    I attach here the job, transformation and error log I put in the bug report, to be sure...
  31. Replies
    17
    Views
    2,886

    I don't know, but in the transformation...

    I don't know, but in the transformation (trans#1), in which I put a "copy rows to result" step, I obtain my URL adress, when I preview the transformation.

    I think the problem is after the...
  32. Thread: Merge Join

    by Gambi
    Replies
    32
    Views
    11,964

    Thanks Sven, it's indeed very easy with the...

    Thanks Sven, it's indeed very easy with the "calculator" step... :D

    Regards,
    Gambi
  33. Replies
    17
    Views
    2,886

    Sorry to insist again, but I've blocked on this...

    Sorry to insist again, but I've blocked on this problem for some days, without discover the solution...

    As I tell it in my last reply, I only added a "Copy rows to result" in my trans#1, and...
  34. Thread: Merge Join

    by Gambi
    Replies
    32
    Views
    11,964

    I've solved my problem, thanks for your...

    I've solved my problem, thanks for your answers...

    Nevertheless, I don't know how do you do Sven with the "Select Values" step to remove duplicated fields after a Merge Join, because in my case,...
  35. Thread: Merge Join

    by Gambi
    Replies
    32
    Views
    11,964

    - I've just red quickly your messages and seen...

    - I've just red quickly your messages and seen your examples, and I have a question with the Merge join step.

    After having executed our transformation, we obtain a combination of rows, with...
  36. Thread: str2dat help

    by Gambi
    Replies
    19
    Views
    3,479

    Well, I've solved my problem ! Effectively,...

    Well, I've solved my problem !

    Effectively, it was a problem with the month format, which is an english format in my case, while Kettle works with a french format. Why, I don't know.

    With a...
  37. Thread: str2dat help

    by Gambi
    Replies
    19
    Views
    3,479

    Well, I'm going to check this and try to solve my...

    Well, I'm going to check this and try to solve my problem, which seems to be a local problem.

    However, just a last question.

    It's seem that the date String I extract is an english date ("Mar"...
  38. Thread: str2dat help

    by Gambi
    Replies
    19
    Views
    3,479

    I have download the last version of Kettle from...

    I have download the last version of Kettle from the sticky notes at the top of the forum. It's seem to be better...

    But your transformation, Sven, doesn't work better...:confused:

    I think I...
  39. Replies
    17
    Views
    2,886

    up. If anyone has a suggestion... Thanks...

    up.

    If anyone has a suggestion...

    Thanks
    Gambi
  40. Replies
    17
    Views
    2,886

    I want to do the same operation. My trans#1...

    I want to do the same operation.

    My trans#1 extract from a file URL adresses. At the end of this transformation, I put a "Copy Rows to result" step.

    Then, I want to download files...
  41. Thread: str2dat help

    by Gambi
    Replies
    19
    Views
    3,479

    The first transformation you sent me doesn't work...

    The first transformation you sent me doesn't work in my PC.

    There is an error of execution ang any results work out...
  42. Replies
    1
    Views
    969

    Conversion String to Date

    Dear,

    I'm sorry to open a new thread for a already treated subject, but I'm in a without issue way.

    I open it to attract the attention of a Chief Data Integrator or any other person,
    to try...
  43. Thread: str2dat help

    by Gambi
    Replies
    19
    Views
    3,479

    Sven, you're right, my date format was wrong. ...

    Sven, you're right, my date format was wrong.

    I'm going to try explain you correctly my problem:

    - I extract several fields from a file and obtain my "string date", as follows:...
  44. Thread: str2dat help

    by Gambi
    Replies
    19
    Views
    3,479

    I tried to run it without preview, but it doesn't...

    I tried to run it without preview, but it doesn't work.

    Thanks for your help Sven.

    If anyone else knows anything about it...

    Thanks,
    Gambi
  45. Thread: str2dat help

    by Gambi
    Replies
    19
    Views
    3,479

    Exactly the same problem

    Dear,

    I would like to convert a String ("29/Mar./2007:HH:mm:ss") to a date, extracted from a log file.

    I tried to use the JavaScript code given by Matt and I obtain the same error message...
  46. More or less the same problem

    Dear,

    I have more or less the same problem.

    With my Trans#1, I obtain the URL adress of Gzip files I would like to download. It's for a daily download.

    So, in my Job, the first step...
Results 1 to 46 of 46
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

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