Hitachi Vantara Pentaho Community Forums

Search Forums:

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

Page 1 of 4 1 2 3 4

Search Forums: Search took 0.02 seconds.

  1. Tried in Kettle 8.0 - works. Edition 8 was most...

    Tried in Kettle 8.0 - works.
    Edition 8 was most stable so far. When I use 8.2 I never know if I'm doing something wrong or this is Pentaho fault...
  2. Transformation Executor - grouping does not work for strings

    I have steps:
    Table In => Transformation executor

    When I try to use 'Parameter name' on tab Parameters taken from string field (same field is used in Row grouping tab, 'field to group rows on')...
  3. Data Mining -> PMI and Weka J48 algorithm

    Hello,

    If I take it correctly, PMI Decision Tree Classifier will produce J48 decision tree model. Right?
    All what I see as a result from this step is:


    Model

    J48 unpruned tree...
  4. Replies
    3
    Views
    614

    Thank you very much indeed guys for explanations....

    Thank you very much indeed guys for explanations.
    I tried Pentaho BI Server several times yet every time I had to give up. This tool never seemed interesting to me. There is something missing there;...
  5. Replies
    3
    Views
    614

    Create OLAP cubes

    Maybe someone can help...
    I've never tired to create OLAP cubes. This subject is absolutely new for me.
    I see Pentaho offers some products to create such data layer; Schema Workbench, Mondrian...
  6. REST client keeps sending "Transfer-Encoding: chunked"

    How to remove header "Transfer-encoding: chunked" from REST client transmision?
    Normally this header should be added when 'content-length' is unknown. But even if I add 'content-length', Pentaho...
  7. Replies
    2
    Views
    335

    Outdated. I solved problem.

    Outdated. I solved problem.
  8. Replies
    2
    Views
    335

    HTTP post - proxy

    For some reason Kettle is not able to use Proxy Host, response: failed to respond
    Same proxy works in REST client step.

    "HTTP post " can work with proxy?
  9. Replies
    2
    Views
    558

    With your help it's evident :-) It works. Thank...

    With your help it's evident :-)
    It works. Thank you very much indeed!
  10. Replies
    2
    Views
    558

    Directory variable in PRD?

    Forgive me that on Kettle forum but PRD oneis dead - I never got there any answer. Maybe someone will tell you how to solve:

    I use PDI where in transformation I have Pentaho Reporting Output...
  11. Replies
    2
    Views
    351

    Nobody would expect but it works ;-) Thank you!

    Nobody would expect but it works ;-)
    Thank you!
  12. Directory name variable in Reporting Designer

    I use PDI where in transformation I have Pentaho Reporting Output step.
    In report I use PDI transformation as data source. Path to this transformation is static path, for instance...
  13. Replies
    2
    Views
    351

    How to find coresponding line in file?

    I use "Get File Names=> Mail" steps to send attachments from some directory. Between them I need step that will check the correct address for each attachment.

    For instance short_filename is...
  14. Replies
    3
    Views
    748

    Get System Info (system date variable) => Select...

    Get System Info (system date variable) => Select Values (Integer)...
    Right?
  15. Replies
    3
    Views
    748

    How to obtain Timestamp in PDI?

    I use Get System Info to have date. Then I use Select Values step and format it to Timestamp.
    But in other steps I see '208/11/19...' or ''####0;-####0' instead of '1541767114000' or similar. ...
  16. Replies
    0
    Views
    427

    HMAC_SHA1 in Kettle

    Hello,

    what would be the simplest method to generate HMAC_SHA1 hash in PDI?
    Something like HMAC_SHA1('secret', 'key')

    Regards,

    G.
  17. This is in fact what I'm doing right now to...

    This is in fact what I'm doing right now to conserve parameters after Input Table step. But if there is no row in table, sql query will return nothing (not even this "Select *, '${Param1}' as...
  18. This will not work since one stream will generate...

    This will not work since one stream will generate nothing if no rows in table.
  19. I do not get it. What step? All fields after...

    I do not get it.
    What step? All fields after Detect Empty stream will be set to null. I need them keep previous values. These parameters are dynamic.
  20. Continue transformation flow even if Table Input has no rows

    Hi,

    I struggle with following scenario:
    In transformation I have table input step. If there are some rows then I count them using Memory Group By and make some calculation. But if there are no...
  21. Any chance for working step "ElasticSearch Bulk Insert"?

    Elastic has Logstash to load data into Elasticsearch. Problem is that this piece of software is really bad quality; actually it does not work with JDBC MySQL.
    What Pentaho is doing in seconds,...
  22. This is what I needed. Have a great day!

    This is what I needed.

    Have a great day!
  23. Can you recommend some trick to create MySQL table to insert data from input?

    Hello there,

    Sometimes it takes time to manually create MySQL table to insert data from some input (if lot of fields).
    Maybe there is some trick to receive ready 'table create' code?
    Regards,
  24. To my surprise it works ;-) Thank you! I have...

    To my surprise it works ;-)
    Thank you!
    I have such 'dates' in text file so automatic conversion does not take place.
  25. Do we have some step to convert AD date into yyyy-MM-dd?

    I have dates as numbers (for instance 42390). I see this post can be solution: https://forums.pentaho.com/threads/161733-Help-with-converting-AD-dates-to-readable-formats/

    But do we have some step...
  26. Replies
    2
    Views
    416

    Thank you!

    Thank you!
  27. Replies
    2
    Views
    416

    When this bug correction take place?

    Just a question about this issue: https://jira.pentaho.com/browse/PDI-17280

    I see it was resolved. But when it will be deployed in PDI?
    I have to wait for next release or PDI will update itself...
  28. U're right. I focused on subissue with status...

    U're right. I focused on subissue with status 'CLOSED'.
    Anyway, PRD and PDI in versions 8.1 do not work together - many bugs.
  29. Can't find bundle for base name org.pentaho.di.trans.steps.pentahoreporting.messages.

    When using Pentaho Reporting Output step and trying to produce PRD report: Can't find bundle for base name org.pentaho.di.trans.steps.pentahoreporting.messages.messages, locale pl_PL

    During this...
  30. Replies
    3
    Views
    1,034

    Possible. Documentation for this step does not...

    Possible. Documentation for this step does not say I need some JAR, where to get it and where it should be placed :-(
    ...
  31. Replies
    3
    Views
    1,034

    ElasticSearch Bulk Insert

    Trying to connect to Elasticsearch (localhost:9200 or 9300). Any idea why this error?

    An unexpected error occurred in Spoon:
    Could not initialize class org.elasticsearch.threadpool.ThreadPool...
  32. Replies
    2
    Views
    1,434

    I see error inside I've created this report...

    I see error inside

    I've created this report in 8.0 not 8.1... Even if I save it in 8.1 still same error
    Transformation is run in 8.0 PDI
  33. Replies
    2
    Views
    1,434

    Pentaho Reporting Output and error

    Pentaho Reporting Output generates error on some PCs (on the other works well). Report and datasource is fine (verified).
    This is java problem?


    2018/06/15 11:29:32 - Pentaho Reporting Output.0...
  34. Better now :-) Thank you!

    Better now :-)
    Thank you!
  35. OK, I found the error. Oryginally directory...

    OK, I found the error. Oryginally directory pointer "getVariable("Internal.Transformation.Filename.Directory"," ")" produce "file://..." prefix. Have to cut it to receive correct file pointer syntax....
  36. Thank you Gutlez for all suggestions. My PDI...

    Thank you Gutlez for all suggestions.

    My PDI inside seems to work. In Transformation properties, Parameters pane, I added 'ExcelFileName' parameter (no default value). In Microsoft Excel Input...
  37. How to pass parameter from PDi To PRD's PDI source?

    I have tranformation:

    Get File Names => Modified Java Script Value (where I create paths for report definition file and output file and path to Excel file) => Pentaho Reporting Output

    PRD...
  38. Replies
    2
    Views
    381

    Hehehe ❤ OK, I will go this direction :-) ...

    Hehehe ❤
    OK, I will go this direction :-)

    Thanks for suggestion
  39. Replies
    2
    Views
    381

    Date "26.03.0218" is correct for PDI

    Hi,

    I have date input "26.03.0218". If I declare this as Date and set mask 'dd.MM.YYYY' this date is... fine.

    Same trick in Select Values step.

    I can imagine I extract year and check range...
  40. Replies
    2
    Views
    994

    Thank you very much for help!

    Thank you very much for help!
  41. Replies
    2
    Views
    994

    Transformation executor and result

    Hi,

    I have transformation:

    Table input => Transformation Executor (Microsoft Excel Output inside) => Copy rows to result

    How to pass Table input rows to step "Copy rows to result"?
    Looks...
  42. Replies
    0
    Views
    307

    Handle cookies in Rest Client?

    Hi,

    is there some way I can handle cookies in Rest Client (save and post)?
    Rest Client does not have any option to manage them?

    Regards
  43. Replies
    0
    Views
    333

    REST Client - session management

    Hi,

    I have to get data from weird API where I need to use http GET then http POST and again http POST (each time server is returning new key).

    I noticed that session is important for the server...
  44. Replies
    1
    Views
    350

    OK, looks like there is auto-update in version 8....

    OK, looks like there is auto-update in version 8. Right?
  45. Replies
    1
    Views
    350

    Where I can find fix for bug?

    Hi Guys,

    where I can find fix for this bug (fixed): http://jira.pentaho.com/browse/PDI-16803

    This will be launched in new release or there is a patch somewhere?

    Regards,

    G.
  46. Thanks, this is what what I do for other...

    Thanks, this is what what I do for other transformations.

    The desired format for MySQL in this project is "2018-1-0"
    I understand that if I produce such date Pentaho will cast error as not...
  47. Thank you for help. I have to find another...

    Thank you for help.
    I have to find another solution; I do not need day information... probably I will always set day to first day of the month.
  48. couldn't convert string [2018-1-0] to a date using format [yyyy/MM/dd HH:mm:ss.SSS]

    Step "Database lookup" or "Insert/Update", I'm trying to check or insert date which is string "2018-1-0' (0 as day is correct format for MySQL) and I receive error:


    Database lookup.0 - DateShort...
  49. Replies
    4
    Views
    813

    Thank you very much for your opinions. Sounds...

    Thank you very much for your opinions. Sounds reasonable.
    I'm learning Report Designer and already I put lot of energy in that. But even if I'am a good swimmer sometimes there are some limits. Not...
  50. Replies
    4
    Views
    813

    Dialog - prompt the user

    Hello,

    Is there any trick to prompt the user (by display a dialog box) to input some value? I need them to define no of the month.

    I see there is an example:

    ...
Results 1 to 50 of 181
Page 1 of 4 1 2 3 4
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

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