US and Worldwide: +1 (866) 660-7555

Search Forums:

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

Page 1 of 58 1 2 3 4

Search Forums: Search took 3.53 seconds.

  1. 1. Filter Rows: If A < B (True, Send to #3 ;...

    1. Filter Rows: If A < B (True, Send to #3 ; False, Send to #2)
    2. Select Values (Swap Columns A and B and Rename them to the appropriate)
    3. Sort Rows A Asc, B Asc
    4. Unique Rows

    Done!
  2. In the other columns (same place as you set the...

    In the other columns (same place as you set the format) are columns called "Decimal" and "Group". These would need to be set as "," and "." respectively for your number format. The format string...
  3. It might have something to do with the parallel...

    It might have something to do with the parallel output of Simple Evaluation.

    Try rebuilding it (Turn off the parallel at Simple Evaluation) and put a dummy step between the simple eval and the...
  4. Replies
    1
    Views
    60

    Variables are a specific concept in PDI. How are...

    Variables are a specific concept in PDI.
    How are you intending to use the field values?

    Perhaps if you explain what you are trying to do, rather than how you are trying to achieve it...
  5. There is an option on PDI steps: "Number of...

    There is an option on PDI steps: "Number of copies to start" that you can change to change how many steps are running in parallel **FOR EACH STEP**

    PDI works best if you keep the number of copies...
  6. Bhanu, Vince is talking about the Modified...

    Bhanu, Vince is talking about the Modified Javascript Values step, not the User Defined Java Expression.

    Vince - Bhanu is talking about a different step, which uses Java expressions, not...
  7. Tomcat is complaining about not being able to...

    Tomcat is complaining about not being able to allocate enough memory.
    The maximum amount of memory that you can allocate in Windows 32 bit is 1500 MB. (give or take a few)

    If there is not enough...
  8. Did you change the MX parameters?

    Did you change the MX parameters?
  9. Why do things the hard way? Use the Microsoft...

    Why do things the hard way?
    Use the Microsoft Excel Writer step, and set the values to protect the sheet.
  10. Could be. Your PROD server might have a...

    Could be. Your PROD server might have a different configuration that requires a password check, where DEV does not.

    Could be.

    Could also be that you're using a dynamic password setting on your...
  11. Replies
    1
    Views
    106

    I think few people use DB repository - there are...

    I think few people use DB repository - there are quite a few limitations with it.
    That said, try user admin password admin
  12. Replies
    4
    Views
    219

    Have you looked in the samples directory? Most...

    Have you looked in the samples directory? Most of these things are in there.
  13. Replies
    4
    Views
    672

    Remember: A Date is a Date is a Date. Formatting...

    Remember: A Date is a Date is a Date. Formatting doesn't change it.

    The common answer on Google is "Make sure your MySQL connector is the same version as your MySQL DB"
  14. Have a good look at the "Get Variables" step.

    Have a good look at the "Get Variables" step.
  15. Reading the requirements, I would actually...

    Reading the requirements, I would actually suggest you restructure your flow.

    Source -> Merge Rows -> Synchronize after Merge
    Destination -^
  16. Replies
    1
    Views
    142

    That appears to be an Oracle Configuration issue:...

    That appears to be an Oracle Configuration issue:
    https://community.oracle.com/thread/2547624
  17. Replies
    4
    Views
    181

    With Windows, when you configure Proxy settings...

    With Windows, when you configure Proxy settings in IE, you are configuring it *FOR ALL APPLICATIONS*

    In the Advanced settings for the Proxy, add your SQL server to the Exceptions list, and then...
  18. Why use Modified JavaScript Value? There's a...

    Why use Modified JavaScript Value?
    There's a Replace in String step, a String Operations step, and a Null If step. One of those will accomplish what you are looking for.
  19. I did a quick test: Generate Rows (10) ->...

    I did a quick test:
    Generate Rows (10) -> Modified Javascript Value

    The Modified Javascript Value step has your exact script.
    My output shows two elements in each row.

    So can you elaborate on...
  20. Replies
    2
    Views
    120

    Why are you doing this with a Modified JavaScript...

    Why are you doing this with a Modified JavaScript Values step?
    It's not showing that it works in one directory and not in another directory.
  21. Or use fixed fields :P

    Or use fixed fields :P
  22. Replies
    3
    Views
    111

    Have a look in your PDI Directory:...

    Have a look in your PDI Directory:
    %PDI%/samples/transformations/Merge Join - Join 2 sorted data sets.ktr
    %PDI%/samples/transformations/Merge rows - mergs 2 streams of data and add a flag.ktr...
  23. It's ugly, but you could do: Text Input -> Add...

    It's ugly, but you could do:
    Text Input -> Add Constant -> Text Output

    Configure the Text Input to bring in 1 column as String(Max)
    Add your new column, and then write out the new file.
  24. Replies
    4
    Views
    150

    Are one of your columns strings? Could that...

    Are one of your columns strings?
    Could that string contain " ?
    If so, the Bulk Loader may be looking for the other half of a string, and waiting forever, since it's not actually there.
  25. You might peek at Sparkl...

    You might peek at Sparkl http://community.pentaho.com/projects/sparkl/
    I have NO idea if it would meet your needs, but it's a place to start.
  26. How do you know that it doesn't insert any rows?...

    How do you know that it doesn't insert any rows?
    How much have you looked at the execution logs?

    Table Output *IS* the step you are looking for.
  27. ? replacement should take care of quoting for...

    ? replacement should take care of quoting for you, as long as the types are defined correctly.

    Please note that Execute SQL isn't intended for SELECT statements - that is what Table Input is for....
  28. Using a Data Grid feeding the string you supplied...

    Using a Data Grid feeding the string you supplied into a Select Values, it wanted the format: yyyy-MM-dd'T'HH:mm:ss.SSSz
  29. Replies
    5
    Views
    346

    Why re-invent the wheel? Also, you will decrease...

    Why re-invent the wheel?
    Also, you will decrease the maintainability of the script, and decrease your performance.

    Modified Javascript Value should be treated as a **LAST** resort, not a primary...
  30. Since the format that you're using is telling it...

    Since the format that you're using is telling it to use local time, and your time jumped at 2AM to 3AM, then 02:00:55 doesn't exist.
    You could try a format of: [yyyy-MM-dd'T'HH:mm:ss.Sz]
  31. 1) Basic SQL issue. You MUST enclose strings in...

    1) Basic SQL issue.
    You MUST enclose strings in '
    from: and lower(comm_val) = email@utr.org
    to: and lower(comm_val) = 'email@utr.org'

    2) Execute SQL Commands is not the step you are looking...
  32. Replies
    5
    Views
    346

    Why not use a Select Values (Meta-Data tab) step,...

    Why not use a Select Values (Meta-Data tab) step, converting from String to Date, and use an Error Handling hop to handle it?
  33. Think of having two parallel streams... "Row...

    Think of having two parallel streams... "Row Results" and "File Results"

    Copy Files to results adds rows to the "File Results" stream.
    Execute for every input row runs the job for each entry in...
  34. Replies
    6
    Views
    160

    Maybe it has something to do with the fact that...

    Maybe it has something to do with the fact that you're trying to put 20 columns worth of data into 9 fields?

    An Array length error shouldn't be a problem that can be solved by changing the file...
  35. Replies
    6
    Views
    160

    Your screenshot cannot be read...

    Your screenshot cannot be read...
  36. Why create another thread?...

    Why create another thread?
    http://forums.pentaho.com/showthread.php?182565-Migration-from-DTS-to-PDI
  37. Remember: Update step still does a lookup first....

    Remember: Update step still does a lookup first.
    So without an index, if you are looking up Ticket_ID, it will do a full table-scan to figure out the RowID first.
    Short answer: YES, put an Index...
  38. Replies
    3
    Views
    251

    If it doesn't find any files (for any reason), it...

    If it doesn't find any files (for any reason), it will still say success and move on to the send email, with no file in the results.
  39. Try changing your logic a little bit... Wrap it...

    Try changing your logic a little bit... Wrap it in a job.
    Replace the Table Output from existing Transform with a Serialize to File
    New Transform follows it with a "De-serialize from File" ->...
  40. You might be able to do a select max(Ticket_ID)...

    You might be able to do a select max(Ticket_ID) from DestTable early in the process, and then filter rows so that any Source.Ticket_ID > Destination.Max(Ticket_ID) goes to an Insert Step, and and...
  41. Replies
    3
    Views
    134

    Maybe your office server doesn't support SSL...

    Maybe your office server doesn't support SSL POP3...
    Try it with SSL off and the port as 110
  42. Replies
    3
    Views
    134

    Mostly likely cause is your Proxy server.

    Mostly likely cause is your Proxy server.
  43. Do you know the name of your temp table in...

    Do you know the name of your temp table in advance?
    If so, use the Table Input step

    Does your Stored Proc return a dataset?
    If so, I seem to recall being able to use "Call" statements in the...
  44. Replies
    5
    Views
    371

    Which version of Windows? Which version of Java?

    Which version of Windows?
    Which version of Java?
  45. Looks like you can. Your lines look right, but...

    Looks like you can.

    Your lines look right, but you'll need to run kitchen with something like:

    kitchen.sh /path/to/prod/jndi -file...
  46. Yes, it is. and it's documented that way.

    Yes, it is. and it's documented that way.
  47. Replies
    15
    Views
    279

    Have a look at...

    Have a look at %KETTLE_HOME%\data-integration\samples\transformations\XML Join - Create a multilayer XML file.ktr


    I think the answer to your question (though I'm not fully understanding it) is...
  48. Replies
    15
    Views
    279

    So... could you not sort by Product Line, and...

    So... could you not sort by Product Line, and then use a Group By step to count the distinct values of Item giving you a set of rows that look like:

    Product Line | Number of Items
    1 | 16
    2 | 5...
  49. Replies
    15
    Views
    279

    Not that I know of. But be sure to also look...

    Not that I know of.

    But be sure to also look at:
    http://type-exit.org/adventures-with-open-source-bi/2010/06/squeezing-the-most-out-of-the-javascript-step-in-pentaho-kettle/

    Maybe try walking...
  50. Replies
    15
    Views
    279

    But that XML wouldn't meet the row requirements...

    But that XML wouldn't meet the row requirements for a standard row would it?

    Remember that all outgoing rows from a step need to have the same layout.
    Are you trying to do something that could be...
Results 1 to 50 of 2854
Page 1 of 58 1 2 3 4