Hitachi Vantara Pentaho Community Forums

Search Forums:

Type: Posts; User: FARICH TRI UTOMO; Keyword(s):

Search Forums: Search took 0.02 seconds.

  1. it works, thank you johanhammink...

    it works, thank you johanhammink
  2. How to Get Max from different Column

    Hi All, Question please

    I got a data with column a, b, c
    which have value(integer) in it

    1,3,5
    4,9,10
    11,5,8
    2,88,1
  3. Filter 0 if there's row which have value more than 0

    here's the case

    i've got a table which got 3 field
    1. id(varchar)
    2. state1(int)
    3. state2(int)
    i've set all of them as primary key, which mean combination of the three field should be unique...
  4. Replies
    0
    Views
    309

    Dynamic Input Normalization

    Problem
    I got a repetitive task to normalize data, for example, i got a csv or an excel of

    id ; name ; age; address; phone
    1; ane; 19; NY; 05547886

    and
    id ; name ; job; saving
    3; ena;...
  5. Hi IamAhmed, i'm researching for the same...

    Hi IamAhmed,

    i'm researching for the same problem
    the best i can do now is to use 2 set variables
    the first one to list the multiple values
    the second is to set one of the value to...
  6. Replies
    9
    Views
    6,239

    Hi Des, just a suggestion maybe you can the...

    Hi Des,

    just a suggestion

    maybe you can the transform the requirement to variables
    and then you can use variables generated to choose the table
  7. Replies
    9
    Views
    1,347

    i'm sorry, i found out that i was wrong subquery...

    i'm sorry, i found out that i was wrong
    subquery or a limit or a variable within a table input step is indeed usable:D
    just that rank and row number is not ( CMIIW:confused:) from here...
  8. Replies
    9
    Views
    1,347

    yes, i can use it to set the variable but as...

    yes, i can use it to set the variable

    but as far as i know, sub select and limit over is not usable in pentaho table input

    or is there alternative way to do it?
  9. Replies
    9
    Views
    1,347

    now i got the last row, but how do i convert it...

    now i got the last row, but how do i convert it to a variable?

    is there a way to extract only the value of id and convert it to variable?
    or is there a way to make table input recognize the last...
  10. Replies
    9
    Views
    1,347

    hi sparkles, thanks for the alternative. i've...

    hi sparkles, thanks for the alternative.

    i've tried Identify Last Row In Stream step with filter row and it works too
    and faster
  11. Replies
    9
    Views
    1,347

    thank you for your answer johanhammink, it works...

    thank you for your answer johanhammink, it works and your information is truly mind opening as i''ve just know that there's dlc plugin for pdi:rolleyes:
  12. Replies
    9
    Views
    1,347

    Getting last row as variable

    lately, i've been pondering about error handling

    is there a way to get last row read as a variable to retry the job instead using loop to reread whole database from start?

    something like this
    ...
  13. Replies
    8
    Views
    817

    Yes, thank you for answering no offense accepted...

    Yes, thank you for answering
    no offense accepted
    i'm new to database

    i'm asking the question abaout id column because at the database i'm working on the id column is not just generated number,...
  14. Replies
    8
    Views
    817

    i'm sorry but, where could i look for my...

    i'm sorry but, where could i look for my PostgreSQL options?
  15. Replies
    8
    Views
    817

    ID Column? is it akin of rownum? what if...

    ID Column? is it akin of rownum?

    what if there's no id column?

    i used to use date of entry but one of the table don't have one
  16. Replies
    8
    Views
    817

    Limited Table Input

    Please help,

    The Case is i've got a external table input transformation which use postgreSQL,
    it works fine until Row 300.000.
    yes, it's stop at row 300.000.
    ...
    the log said that the...
  17. Replies
    3
    Views
    1,698

    It works! thank you very much. it seem i...

    It works!

    thank you very much.

    it seem i missed three jdbc drivers, installing it in lib folder solve the problem
  18. Replies
    3
    Views
    1,698

    Connection to oracle

    Please Help

    I tried to connect to database with odbc. for driver i used oracle instant client and have set up the dsn.
    i tested the dsn with connection from office and it works, but with pentaho,...
Results 1 to 18 of 18
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

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