Hitachi Vantara Pentaho Community Forums
Results 1 to 7 of 7

Thread: variables

  1. #1

    Default variables

    Hello,

    I am trying to use a TABLE INPUT with a SQL

    select * from tabeladados where year(datacontacto)=2008 and month(datacontacto)=${MES} and day(datacontacto)=${DIA}

    When i do the run i have added MES and DIA to variables and i place there the value i want.

    Can this takes the values from one list or something else ?

    I am running this one by one.
    OK for the moment I am trying to use AutoHotKey to cycle through one month

    The transformation crash when i try to get all the values even if just from one month.

    So i need something that places days there and keeps it running but not runs everything straight but makes a stop in the middle.

    I just found the update option in the output to txt file and it is a very nice feature that avoids me to have to run everything over and over.

    By the way. Is there a keyboard shortcut to close one window in keetle or to edit a step without having to use the mouse ?


    thank you
    Last edited by pjssms; 04-02-2008 at 07:36 AM.

  2. #2
    Join Date
    May 2006
    Posts
    4,882

    Default

    For the processing of multiple values you have to write a job around it... have a look in the samples directory, it contains an example called "process all tables" which is probably near what you need.

    Regards,
    Sven

  3. #3

    Default

    Hello,

    I have tried that approach. One of the days give a failure and then all the steps following fail.

    Sending one by one allows that everything runs even if a step fails.

    I can not run the steps in parallel.

  4. #4
    Join Date
    May 2006
    Posts
    4,882

    Default

    "Taking values from a list or something else" from your original post would suffer from the same problem. When wrapping the transformation you can determine what to do when the transformation fails.

    Regards,
    Sven

  5. #5

    Default

    The error i got is always

    [Informix][Informix ODBC Driver]Unspecified System Error = -21005.

  6. #6
    Join Date
    May 2006
    Posts
    4,882

    Default

    If I understand it's only for certain values that it fails, that execution of the transformation would fail and you could make the job that wraps the transformation continue with the rest of the values.

    For the -21005 ... maybe you have mismatched locales (extended characters or so) in your input.

    Regards,
    Sven

  7. #7

    Default error

    Hello,

    I have created the job following the sample. Thank you!.

    It runs now once per day. But when one day fails the job is stopped.

    How can i treat the failures and keep going with the process ?


    Thank You,

    Paulo Santos

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

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