Hitachi Vantara Pentaho Community Forums

Search Forums:

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

Page 1 of 14 1 2 3 4

Search Forums: Search took 0.03 seconds.

  1. In the Tranformation or Job properties you can...

    In the Tranformation or Job properties you can adjust logging options and also specify a database / tables to write the logging
  2. In the "Repository Explorer" you can rename a...

    In the "Repository Explorer" you can rename a transformation or job. You can also move them to another directory. I don't know why you can't do that in transformation and job properties anymore
    When...
  3. The first 3 are managed in the index.jsp situated...

    The first 3 are managed in the index.jsp situated in ..\pentaho-server\tomcat\webapps\pentaho\mantle\home
    Disaible the parts you want to remove
  4. Replies
    2
    Views
    402

    I would do that with a formula step....

    I would do that with a formula step. MAX([a];[b];[c])
  5. PDI 7.2 is not a regular version so I think you...

    PDI 7.2 is not a regular version so I think you are using 7.1?
    Is it due to the fact that the default settings for a transformation is a nr of rows in a rowset is 10000? So the text output wil wait...
  6. Replies
    1
    Views
    367

    With the "Date Range Input Component" you can...

    With the "Date Range Input Component" you can make a range of a year
  7. Replies
    6
    Views
    1,761

    You can have a look at the cdc plugin

    You can have a look at the cdc plugin
  8. Replies
    6
    Views
    1,761

    To clear chache for a single query use the "CDA...

    To clear chache for a single query use the "CDA Cache Manager". You can find that option under Tools
  9. It is not changed since I guess version 7.0. To...

    It is not changed since I guess version 7.0. To make a database repository see: https://help.pentaho.com/Documentation/8.2/Products/Data_Integration/Repositories
  10. I think you means this post...

    I think you means this post
    https://forums.pentaho.com/threads/230589-Understanding-row-flattener/
  11. Check if the line starts with CHAINAGE and send...

    Check if the line starts with CHAINAGE and send that line to a seperate step. Then remove the text part CHAINAGE so you only have the red number. Then join "Cartesion join" that step with the rest of...
  12. Replies
    4
    Views
    402

    You can also create a transformation which from...

    You can also create a transformation which from your DB Repo creates kdb files (just xml) for all the connections in the tables r_database, r_database_attribute, r_database_contype and r_database_type
  13. You cannot use in one transformation a Set...

    You cannot use in one transformation a Set Variabeles and use that variable in the same transformation.
    So in the first transformation set the variable.
    In the second transformation use that...
  14. Make a transformation that determined last week...

    Make a transformation that determined last week and update a variable with that value. You can use that variable in the subject of the mail or the name of an Excel file
  15. Replies
    2
    Views
    356

    Have a look here...

    Have a look here
    https://wiki.pentaho.com/display/EAI/MySQL
  16. Replies
    4
    Views
    651

    You have to change the line var content =...

    You have to change the line var content = Packages.be.ibridge.kettle.core.Const.createByteArray(file.length()); to var content = Packages.org.pentaho.di.core.Const.createByteArray(file.length());
  17. When you put your file name in a result column...

    When you put your file name in a result column you can change the column 2 (contant number) and add 1 if the filename changed. You can do that with f.e. javascript
  18. I was aible to install it from within PDI but you...

    I was aible to install it from within PDI but you can also download the plugin from here https://www.pentaho.com/marketplace/
    Then unzip file and place the downloaded directory...
  19. You can also use the "Special Character Remover"...

    You can also use the "Special Character Remover" plugin for that
  20. With WebSpoon you can use the pentaho-server to...

    With WebSpoon you can use the pentaho-server to see and develop transformations and jobs. See https://github.com/HiromuHota/pentaho-kettle
  21. Why are you missing data? With the merge join...

    Why are you missing data? With the merge join step you can also use a left join
  22. You can do that with a sql query: select * from...

    You can do that with a sql query:
    select * from table t1
    inner join table t2 on t1.id = t2.id and t1.state1 = t2.state1
    where t1.state2 = 0 and t2.state2 <> 0
  23. I guess you are using version 8.1. In that...

    I guess you are using version 8.1. In that version passing parameters to another transformation is not working as expected. See f.e. https://jira.pentaho.com/browse/PDI-17343 . This issue is fixed in...
  24. Replies
    5
    Views
    966

    He is working with version 4.1. In those older...

    He is working with version 4.1. In those older versions the directery structure was different. You can try to refresh the "System Settings". Also on the computer where Pentaho is running in the...
  25. You can look at a cross-tab report

    You can look at a cross-tab report
  26. To make a list of sheetnames in Excel - Take...

    To make a list of sheetnames in Excel
    - Take Excel input. In Sheet tab leave Sheet name empty and in start row / start column value 0
    - In Fields tab create one record.
    - in additional output...
  27. When push button "SQL" in table output, Update or...

    When push button "SQL" in table output, Update or Insert / Update step you get create statement when table doesn't exist
  28. Replies
    6
    Views
    659

    What is the difference between the Excel files?...

    What is the difference between the Excel files? Can you share those files?
  29. Replies
    2
    Views
    426

    Because you want to use EE edition I assume you...

    Because you want to use EE edition I assume you are a Pentaho customer. Then I would ask Pentaho for that inslaller
  30. Why not working with a File repository? You can...

    Why not working with a File repository? You can then develop on your own machine with the files on the linux server or use GIT to manage the files
    But you can use a Pentaho Reporitory connecting to...
  31. Replies
    4
    Views
    1,024

    Is there something in the logging file?

    Is there something in the logging file?
  32. You can use sc.exe for that. It should looks like...

    You can use sc.exe for that. It should looks like something like
    sc.exe create <your_service_name> binPath="<path to your bat file>"
    You have to run that command as a administrator
  33. Replies
    2
    Views
    820

    1. The MaxPermSize is the maximum size for the...

    1. The MaxPermSize is the maximum size for the permanent generation heap, a heap that holds the byte code of classes and is kept separated from the object heap containing the actual instances.

    3....
  34. If you send all values, so also value "A" to the...

    If you send all values, so also value "A" to the main stream but send value "A" also to the "Detect empty stream" step. When there is no value "A" this will create a record that you can send to a...
  35. With the "Switch / Case" step you can send...

    With the "Switch / Case" step you can send records with the value "A" to another step. Write those record to a file and then append the to streams together
  36. The .kettle directory is in the KETTLE_HOME...

    The .kettle directory is in the KETTLE_HOME system or shell variable. When that variable not set it is in the /kome/user/.kettle of the user running pdi. You can also change the spoon.sh file to...
  37. Replies
    1
    Views
    609

    You have to create users in the ldap server.

    You have to create users in the ldap server.
  38. You can also use the step "CSV File input". This...

    You can also use the step "CSV File input". This step uses less memory and is faster. See also http://pentaho-bi-suite.blogspot.com/2015/12/tip-difference-between-text-file-input.html
  39. Have a look at this post to remove big-data...

    Have a look at this post to remove big-data plugin.
    https://blog.twineworks.com/improving-startup-time-of-pentaho-data-integration-78d0803c559b
  40. With the step "Analytic Query" you can get the...

    With the step "Analytic Query" you can get the value of a field from a previous record
  41. You know the number of columns. Then count the...

    You know the number of columns. Then count the number of a separator in the first line of the txt file.
    You can count the number of , with a "User Defined Java Expression". See for example:...
  42. In the samples folder ..\samples\jobs\run_all\Run...

    In the samples folder ..\samples\jobs\run_all\Run all sample transformations.kjb show how to use a variable with different values
    1. Job1 with transformation1 and job2 (execute for every input row)...
  43. In J2 plave a transformation with the step : "Get...

    In J2 plave a transformation with the step : "Get files from result" and use that to set a variable with the filename. You can use this variable in the mail entry
  44. Replies
    4
    Views
    1,210

    A prpt file is just a zip file. So look for the...

    A prpt file is just a zip file. So look for the meta.xml within this file and change the version and the Engine to an older version. Save it and then try to open the report in the older version of...
  45. Replies
    3
    Views
    439

    This is the expected behaviour. Copy the input...

    This is the expected behaviour. Copy the input stream to Dimension update and Detect empty stream. When there are records in input the Detect empty stream don't produce a record. When no records in...
  46. Look at the compare field step:...

    Look at the compare field step: https://wiki.pentaho.com/display/EAI/Compare+Fields
  47. With a dat file you mean a txt file? - First...

    With a dat file you mean a txt file?
    - First write the data to a file.
    - Then write the body with txt file output to the same file and check "Append" in the Content tab
  48. With Data Validator step you can check with...

    With Data Validator step you can check with Regular expression : ^[-]?\d*[.]?\d*$
    Here the . is decimal sign
  49. With the Select values step change the field to a...

    With the Select values step change the field to a number field. Then connect 2 sort rows to that step. The correct values are numbers and the errors are string values.
    Then change the number values...
  50. What is in the log files?

    What is in the log files?
Results 1 to 50 of 691
Page 1 of 14 1 2 3 4
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

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