Hitachi Vantara Pentaho Community Forums

Search Forums:

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

Page 1 of 29 1 2 3 4

Search Forums: Search took 0.04 seconds.

  1. Replies
    2
    Views
    1,464

    RE: insert/update to identity table

    Thanks for your reply...


    I initially tried to use that table output step - but it doesn't seem to offer any way to choose which fields go where.



    So I tried adding a select values before...
  2. RE: getting a column value from a previous row

    the manual doesn't really tell you that you use row.getValue(4) since the row is an array.


    One forum references the API, but I am unable to find the JavaDoc or whatever the API documentation is...
  3. Replies
    1
    Views
    938

    Example using variables

    Does anyone have any examples of using variables? Specifically, I want to set a variable in one step and reference that variable in another step. I haven't been able to get it to work correctly,...
  4. getting a column value from a previous row

    I have tried various combinations of getName and X.getInteger in the code below in order to get a value of a column from the previous row through the JS transform. But I keep getting an "undefined"...
  5. having trouble running in eclipse

    I keep getting this


    java.lang.UnsatisfiedLinkError: no swt-win32-3232 in java.library.path



    I've tried -Djava.library.path=c:\pentahoDesign\kettle\libswt\win32\
  6. Replies
    1
    Views
    1,029

    Slowly changing dimensions

    In the file Building-data.warehouses-using-open-source-tecnologies-v146.pdf there is an example for SCD type 2. The thing is that i dont know the source for the first step called Read Tabla...
  7. Replies
    4
    Views
    1,046

    RE: Build Instructions?

    with the ant build.xml you can create a new kettle.jar
    Hope that helps,
    Jens
  8. Replies
    4
    Views
    1,046

    RE: Build Instructions?

    I actually wasn't asking a Java question - the question is whether there was something else I needed to build from the source.


    I'm assuming by your answers that I specified the two targets...
  9. Replies
    2
    Views
    1,267

    RE: Readin repositories.xml

    I am sorry
  10. Replies
    2
    Views
    1,267

    Readin repositories.xml

    Where find the repositories.xml Pan and Kitchen into Linux?


    I put environment variable $KETTLE_REPOSITORIES="/usr/local/Kettle-2.3.1/repositories.xml"



    But don't working.
  11. Replies
    7
    Views
    5,490

    Slowly Changing Dimensions

    I would like to know how to make a Slowly Changing Dimension with Spoon. I have the Dimension Table and the time table. How can i do it?Thanks
  12. Replies
    4
    Views
    1,096

    RE: empty row with dimension/lookup

    Excuse me, my English is not good. As I record data in the empty line that is created automatically in the dimension by kettle with key 0? , As I accede the first time to key 0 to fill up the empty...
  13. Replies
    4
    Views
    1,096

    RE: empty row with dimension/lookup

    Thanks for the answer.
    My idea is to intertar the not defined phrase “” in the automatically created empty row with key 0,
    stops in the case of not finding in that table no key gives back key...
  14. RE: How to Output XML Data with more than simple Parent / Row Elements

    Is this different from the Output XML step?


    I looked in SVM at the code and I saw the AddXML step, but I don't see it in the UI...
  15. RE: How to Output XML Data with more than simple Parent / Row Elements

    Sounds great!


    Is it in 2.3.1? I don't see it...
  16. Replies
    4
    Views
    1,096

    empty row with dimension/lookup

    Hello forum, I use kettle 2.3.1 to make Dimension lookup/update on a dimension, but when I always use it creates a row to me in target and it sends an error to me of referential integrity, since some...
  17. Replies
    0
    Views
    771

    Xml input to Table outpu

    Hi,

    I want the code to transform Xml input to Table output using kettle java API.

    Thanks&Regards
    Subhashini
  18. Replies
    9
    Views
    1,415

    RE: Turn off step by variable?

    Thanks Matt!!!!


    What Service. I'll check it out when I get back from vacation. Tis Thanks Giving Week Here.



    I really am thankful for all your hard work on this project It shows how much...
  19. Replies
    9
    Views
    1,415

    RE: Turn off step by variable?

    The Replace Vars I was just playing around with.

    Here is some of the output. ( If you can See It )

    It really does cause both to Fire. ( Sorry I'm at a dead end with this one ) I can do the...
  20. Replies
    9
    Views
    1,415

    RE: Turn off step by variable?

    Sorry Matt, I thought that would look better.
  21. Replies
    9
    Views
    1,415

    RE: Turn off step by variable?

    Sorry Matt I cant get your idea to work. Each Query executes any way.


    Below you can see the results....
  22. How to Output XML Data with more than simple Parent / Row Elements

    I am trying to convert Excel data to an XML file that has a more complicated schema than what the XML Output Step seems to provide. What I am trying to do, I would imagine, is a very common thing so...
  23. Replies
    9
    Views
    1,415

    RE: Turn off step by variable?

    I like that idea. But I would still like to avoid calling them in the first place.


    Cant there be a way to:



    If a do path x
    if b do path y
  24. Replies
    9
    Views
    1,415

    Turn off step by variable?

    Can some one please explain hor if we can turn on/off a Step or hop by be value of a variable?


    For example I have 3 databases connections. All 3 have Different Database vendors and have 3...
  25. RE: sql extracting year and month from timestamp

    Jens


    Thanks will give it a bash. :)



    Regards
  26. RE: sql extracting year and month from timestamp

    Thanks again I have managed to open the samples but that still does not answer my initial question which is I am extracting the year and month from a timestamp e.g. '2007-07-11 123123' ===> year =...
  27. RE: sql extracting year and month from timestamp

    Got it!! Thanks :)
  28. RE: sql extracting year and month from timestamp

    :) Stop making fun of me I am serious


    Please help :)



    Regards
  29. RE: sql extracting year and month from timestamp

    hi


    how do i open the extract date from filename.ktr in my samples directory in windows i tried open with spoon it doesnt work, open with chef it doesnt work.



    Please help.
  30. RE: sql extracting year and month from timestamp

    Thanks


    have 2.3.0 which means i have to update :( again. :)
  31. RE: sql extracting year and month from timestamp

    hi


    This might sound like a trivial question but how do i go to the samples.



    regards
  32. sql extracting year and month from timestamp

    hi


    I would like to extract the year and month from a timestamp field e.g 200705 from '2007-05-01' as numeric Can someone please help.



    Regards
  33. "Building data warehouses using open source technologies" transformation examples...

    Attachment: examples.tar.gz Michel Jansen wrote this document mentioned above which is very interesting. Unfortunatly the transformations described in the document were not delivered in any...
  34. stopping execution of a transformation

    Hello,


    I'd like to stop the execution of a transformation or a job launched by pan or kitchen but I can't



    Please help
  35. Replies
    5
    Views
    1,313

    RE: File Lookup

    Let me tell you that Kettle is a fantastic tool ...
    i don't point so much limitations in Kettle.
    In my opinion Kettle is a much more easy tool to work with than OWB.
    For me OWB is a monster !

    ...
  36. Replies
    5
    Views
    1,313

    RE: File Lookup

    Ok, thanks Matt for the quick answer !


    If i understood i cannot insert the Text File Input in the middle of a stream !?



    In my situation i do not know at the beginning of the stream the...
  37. Replies
    5
    Views
    1,313

    File Lookup

    Hi,


    i need a way to make lookups in a txt file to retrive data in it.
    Unfortunately in Kettle we cannot link a previous step with a File Extract Step.



    In Oracle WareHouseBuilder the...
  38. Replies
    1
    Views
    1,214

    Http download File Error

    Hi,


    In Chef, using the Http download file, everything works ok. I dl the file to my C: Drive but when I try to open the file, I can not open it. This happens with excel, pdf and other files.

    ...
  39. Replies
    1
    Views
    1,037

    sting == string

    I am having string comparison problems in the javascript step. No problem comparing integers.


    if (string1 == sting2)
    { do someting; }



    Do something never gets done. Any ideas?
  40. Replies
    1
    Views
    1,100

    Spoon tool

    Hi,


    I would like to know how i can make a dimension table from two normal tables. I have tried the join rows but i dont know how i can generate the new table
  41. Replies
    4
    Views
    1,753

    RE: only half of records get inserted

    Figured it out. I had to select that option for all steps and it worked after I did that. Thanks
  42. Copy of text files using parameters

    Could somebody show me an example on how to make a transformation, copying one text file to another text file ?


    The only feature that I need is that the name of the input file and the output...
  43. Replies
    4
    Views
    1,753

    RE: only half of records get inserted

    Thanks Clavigine. I did that but it turned the last hop to red. I still went ahead and ran it and it did the same thing, i-e half rows in one table and half in second. Do I need one more step between...
  44. RE: use a same script SQL for several owners of the same table

    I solved my problem by creating synonyms in the Oracle Database.
    I just parameterized the creation of these synonyms, and as that I do not need to name the table's owner in the script SQL. And it's...
  45. RE: use a same script SQL for several owners of the same table

    Attachment: owner_log.doc i declared “owner” like a environment variable.
    i have Also check the "Replace environment variables" in the table input step... but no succeed


    I already use...
  46. Error into Linux Red Hat Enterprise

    I cannot execute chef or spoon within Red Hat, and put my variables of environment thus:


    export ANT_HOME="/usr/local/apache-ant-1.6.5"



    export XALAN_HOME="/usr/local/xalan-j_2_7_0"
  47. Replies
    4
    Views
    1,753

    only half of records get inserted

    Hi, I am new to this forum and new to Kettle. I just created a simple transformation by selection one source table and mapping it to to target tables. The source table has about 210000 rows. When I...
  48. RE: Field [R5] couldn't be found in the input stream! (README)

    .
  49. RE: Field [R5] couldn't be found in the input stream!

    Matt:


    Thank you for your responses.



    What I really want to do, is to copy one file to another, and all filenames are set by means of parameters. I don't want to join rows.
  50. RE: Field [R5] couldn't be found in the input stream!

    Thanks Matt, but just the first record is copied.
Results 1 to 50 of 1403
Page 1 of 29 1 2 3 4
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

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