Hitachi Vantara Pentaho Community Forums

Search Forums:

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

Page 1 of 4 1 2 3 4

Search Forums: Search took 0.02 seconds.

  1. Replies
    0
    Views
    317

    list filenames

    How to list filenames which is available in browser

    Get filenames and directories with http url is not working with username and password.

    http://username:password@URL

    Can anyone suggest the...
  2. Replies
    0
    Views
    374

    metadata injection with sort

    Array index out of exception :0 exception when i use with metadata injector step
  3. Replies
    0
    Views
    633

    excel writer issue

    Hi,

    I am facing excel writer with below issue using Pentaho 7.1.0.12 Version in Unix. I am using java8 version. Is there any workaround without downgrading java version. I tried with both xls...
  4. Thread: append

    by pentaho2013
    Replies
    4
    Views
    833

    YEs, if it is space at beginning it has to append...

    YEs, if it is space at beginning it has to append with the previous row. Is there any other way without using udjc step
  5. Thread: append

    by pentaho2013
    Replies
    4
    Views
    833

    append

    Hi,

    Which component i need to use to get the below output.

    Input is attached below

    Output has to be below like this

    text
    ====
  6. Replies
    0
    Views
    405

    error information

    How to capture the previous transformation error information with exact keyword in the parent job by using js/any
  7. Thread: connection

    by pentaho2013
    Replies
    0
    Views
    347

    connection

    Hi,

    Fetching datatypes for any database :

    1) When we use generic connection with table input and use metadata stream component we get Number datatype as Integer or bignumber
    2) When we use...
  8. Replies
    1
    Views
    600

    Multiple Column

    How can we split multiple column values with a single component.
    I have 2 or more columns to split based on comma then i should multiple split field to rows component.
    is there any better way to...
  9. Thread: Parse Data

    by pentaho2013
    Replies
    8
    Views
    1,096

    Thank You so much. Your solution works perfectly

    Thank You so much. Your solution works perfectly
  10. Thread: Parse Data

    by pentaho2013
    Replies
    8
    Views
    1,096

    Sorry Marabu, I am not getting how to do this...

    Sorry Marabu, I am not getting how to do this approach totally.

    My data might be 1-3 or 10-16/2. If it is 1-3 it has to be 1,2,3 and if it is 10-16/2 then it has to be 10,12,14,16. All the above...
  11. Thread: Parse Data

    by pentaho2013
    Replies
    8
    Views
    1,096

    It became too complex.. if it is */5 */2 1-3 */3...

    It became too complex.. if it is */5 */2 1-3 */3
    final output has to be 0,5,10,15,20,25,30,35,40,45,50,55,60 0,2,4,6,8,10,12,14,16,18,20,22 1,2,3 0,3,6,9
  12. Thread: Parse Data

    by pentaho2013
    Replies
    8
    Views
    1,096

    Thanks Marabu.

    Thanks Marabu.
  13. Thread: Parse Data

    by pentaho2013
    Replies
    8
    Views
    1,096

    Parse Data

    Hi,

    Is there a way to parse data dynamically if we have the scenario like this
    My input String is */5 */2 2 */3
    My output String should look like 5,10,15,20,25,30,35,40,45,50,55,60 ...
  14. Replies
    3
    Views
    634

    But if we concatenate with grouping when we split...

    But if we concatenate with grouping when we split field to rows we need to use multiple components for spliting the data to rows then it becomes a cross join is there any way which we can solve this...
  15. Replies
    3
    Views
    634

    Denormalization

    Values are not denormalizing properly. It is giving last/first value when we define key and group column

    Below is the attached transformation sample. Pls correct me if any setting in the...
  16. Thread: key pair

    by pentaho2013
    Replies
    4
    Views
    618

    Not with Row Normalizer. I have attached sample...

    Not with Row Normalizer. I have attached sample with row denormalizer. Thanks for ur inputs.
  17. Thread: key pair

    by pentaho2013
    Replies
    4
    Views
    618

    I am not able to get what kind of grouping field...

    I am not able to get what kind of grouping field has to be added to get the below proper result. I tried with grouping field as TYPE but id din't work for me. Below is my partial solution.
  18. Thread: key pair

    by pentaho2013
    Replies
    4
    Views
    618

    key pair

    Hi,

    Need help on how to transform the below source to expected output.

    Output.



    SNAME
    SDATE
  19. Thread: denorm

    by pentaho2013
    Replies
    5
    Views
    831

    Attached with partial ktr. I tried only append...

    Attached with partial ktr. I tried only append not able to get what has to be done.

    Any help which i am looking for the below outputs

    output 1:



    ident
    name
  20. Thread: denorm

    by pentaho2013
    Replies
    5
    Views
    831

    Thanks for your help. I have a doubt instead...

    Thanks for your help.

    I have a doubt instead of parsing and splitting entire file i want final output as which is mentioned in output 2. I have two files data which is shown in earlier data grid...
  21. Thread: denorm

    by pentaho2013
    Replies
    5
    Views
    831

    I don't think previous pattern will solve my...

    I don't think previous pattern will solve my whole problem.. How can we combine and denormalize and search the specific string and get the results like output 1 and output 2

    Can u help me on this
  22. Thread: denorm

    by pentaho2013
    Replies
    5
    Views
    831

    denorm

    Hi,

    I am attaching my input scenario of how the data looks like and i am expecting two output results .

    Output 1:



    ident
    name1
  23. Replies
    2
    Views
    640

    Thanks Marabu

    Thanks Marabu
  24. Replies
    2
    Views
    640

    Dynamic Combine

    Hi,

    I want to combine string value based on other value dynamically. If any yes flag is coming repetitively then it has to consider last 'N' Value so that it will combine my expected result.
    ...
  25. Thread: Data

    by pentaho2013
    Replies
    5
    Views
    768

    Now is there any way to correct utf-8 data

    Now is there any way to correct utf-8 data
  26. Thread: Data

    by pentaho2013
    Replies
    5
    Views
    768

    Whatever you have said i agree. Is there any way...

    Whatever you have said i agree. Is there any way to correct the data. I am attaching the file and ktr.

    Please guide me how to resolve this issue.
  27. Thread: Data

    by pentaho2013
    Replies
    5
    Views
    768

    Data

    Hi,

    I am getting some values as question mark which is shown in below image. But how can i correct with correct value I have used "UTF-8" when reading from the text file input.

    15897
  28. Thread: Format

    by pentaho2013
    Replies
    4
    Views
    767

    Thanks Marabu

    Thanks Marabu
  29. Thread: Format

    by pentaho2013
    Replies
    4
    Views
    767

    Thanks Marabu, But if i denormalize the data i...

    Thanks Marabu,

    But if i denormalize the data i am not expecting the correct result.. I have attached in the sample it is rounding up.

    Can you help on this
  30. Thread: Format

    by pentaho2013
    Replies
    4
    Views
    767

    Format

    Hi,

    Basically my input is in the string format and my final output i am looking in double value which was showing same as input. It should not get trimmed of any values.

    I am attaching the...
  31. Replies
    0
    Views
    418

    Shell Doubt

    I am trying to do ssh using pentaho "Execute a Shell Script" component

    ssh -i /apps/abc/.ssh/id_rsa Serverxxxxxxx.z

    when i try this i am facing the below error

    (stderr) Pseudo-terminal will...
  32. Thread: Component

    by pentaho2013
    Replies
    5
    Views
    971

    Yes... Thanks for your valuable answer. Is...

    Yes... Thanks for your valuable answer.

    Is there any way which we can clean it up manually . If yes in which place should i clean it up
  33. Thread: Component

    by pentaho2013
    Replies
    5
    Views
    971

    IS there any way which we can overcome this

    IS there any way which we can overcome this
  34. Thread: Error

    by pentaho2013
    Replies
    0
    Views
    455

    Error

    Hi,

    When i am importing jobs and transformations using command line utility i see below issues. How can i overcome this issue. I build the jobs in master node and importing the jobs in other QA...
  35. Thread: Component

    by pentaho2013
    Replies
    5
    Views
    971

    Component

    When we use execute shell script component I see issue in the log file But we don't know how it is getting generated with some garbage value

    ...
  36. Thread: Pdi

    by pentaho2013
    Replies
    2
    Views
    609

    Oh Ok.. But I am not happy with your answer ...

    Oh Ok.. But I am not happy with your answer

    Anyway thanks for your valuable reply
  37. Thread: Pdi

    by pentaho2013
    Replies
    2
    Views
    609

    Pdi

    Hi,

    Is there any workaround to do restartability feature in Pentaho Community Edition.

    If yes can you please share your thoughts how can we do this?

    Suppose if we have two parallel jobs if...
  38. Thread: DI Error

    by pentaho2013
    Replies
    0
    Views
    519

    DI Error

    Hi,

    When i am importing jobs and transformations using command line utility i see below issues. How can i overcome this issue.

    - Unable to save repository element [172.21.35.888]
    2015/08/01...
  39. Thread: DI Help

    by pentaho2013
    Replies
    0
    Views
    434

    DI Help

    How to know how many users are opened same transformations and jobs in the pentaho DI repository.

    Suppose i have 10 users in that 3 users has opened the same transformation or job then how would...
  40. Thread: threads

    by pentaho2013
    Replies
    1
    Views
    562

    threads

    Hi,

    How many parallel thread does pentaho data integration can handle when running the jobs. What is the maximum limit ?

    Suppose if i have 20 jobs to run parallely will that work if not how...
  41. Thread: repo

    by pentaho2013
    Replies
    2
    Views
    642

    It is DI repository not database repository.

    It is DI repository not database repository.
  42. Thread: Row Value

    by pentaho2013
    Replies
    10
    Views
    1,547

    thanks a lot marabu. But i see one issue if i...

    thanks a lot marabu.

    But i see one issue if i get some data like this format. If any value is null it is not working. How can i handle this scenario.
  43. Thread: repo

    by pentaho2013
    Replies
    2
    Views
    642

    repo

    How to rename the PDI repository using command line.
  44. Thread: Row Value

    by pentaho2013
    Replies
    10
    Views
    1,547

    Thank you so much marabu. You have mentioned...

    Thank you so much marabu.

    You have mentioned about "Repeat" where it will help me in the current transformation which you have given me example.
  45. Thread: Row Value

    by pentaho2013
    Replies
    10
    Views
    1,547

    @Marabu : Need your help please

    @Marabu : Need your help please
  46. Thread: Row Value

    by pentaho2013
    Replies
    10
    Views
    1,547

    Input is dynamic..

    Input is dynamic..
  47. Thread: Row Value

    by pentaho2013
    Replies
    10
    Views
    1,547

    Row Value

    Hi,
  48. Thread: scenario

    by pentaho2013
    Replies
    0
    Views
    354

    s

    ssss
  49. Replies
    1
    Views
    561

    Parallelism

    Hi,

    I am starting jobs parallely with restartability scenario. for example i have two jobs test1 and test2 with the restartability and running in parallel. Now if test1 gets failed and test2 gets...
  50. Replies
    0
    Views
    441

    Integration

    Hi,

    How to integrate spark in Pentaho Data Integration. I am using latest version of pentaho community edition i.e 5.3 but i didnt see "spark submit job component". How do i get it.
    ...
Results 1 to 50 of 151
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.