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

Search Forums:

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

Page 1 of 50 1 2 3 4

Search Forums: Search took 0.16 seconds.

  1. Replies
    19
    Views
    145

    So you will want to put a Unique in there too....

    So you will want to put a Unique in there too.
    What makes the rows Unique? combination of cust_is and ord_id?

    So far:
    Text File -> Sort (cust_id, ord_id; unique rows only) -> Group By (cust_id)
  2. Replies
    19
    Views
    145

    So what is your expected outcome for two lines: ...

    So what is your expected outcome for two lines:



    ord_id
    cust_id
    cust_zip
    cust_first_ord_date
    cust_last_ord_date
    cust_life_ord_subtotal_amt
  3. Replies
    19
    Views
    145

    Where is the transform that goes with it? Also,...

    Where is the transform that goes with it?
    Also, did you notice that your data isn't valid? There is no date: 2011-03-79 or 2013-12-336
  4. Replies
    19
    Views
    145

    It's still not something that I can run from...

    It's still not something that I can run from here...

    SIMPLIFY the transformation just to what you want us to help with:
    Text File Input -> Group By -> Group By

    Build your sample data by...
  5. Replies
    19
    Views
    145

    Ok, so simplify your sample. Text File Input ->...

    Ok, so simplify your sample.
    Text File Input -> Group By 2

    Now remove everything in the Group By box except cust_id, leaving the Order Count as you have it.
    Now Preview the results.

    Does that...
  6. Replies
    19
    Views
    145

    So where does the Sample CSV fit into your...

    So where does the Sample CSV fit into your Transform?
    Which Group By do you think is not working right (Group By 2 or Group By 2 2 )?

    Did you follow the note in the Group By (Must have data...
  7. Or if you are using a very new PDI, you could...

    Or if you are using a very new PDI, you could look at the Transformation Executor step.
  8. What you describe is exactly what the combination...

    What you describe is exactly what the combination step is supposed to do:
    1) Look up the value in dimension table
    2) Insert the value in the dimension table if the value doesn't exist
    3) Return...
  9. You haven't given the Denormalizer any way to...

    You haven't given the Denormalizer any way to know what makes a new row, so it assumes that it is all the same row (look at your group configuration in the Denormalizer step) and only uses the last...
  10. Sounds like Network throughput latency. We...

    Sounds like Network throughput latency.

    We (the PDI community) usually recommend putting PDI as close to your database(s) as possible (in terms of network hops)
  11. I have heard of a few people getting it working,...

    I have heard of a few people getting it working, but I've never had it work correctly.
    Going to cron (or Windows Scheduled event) has had a 100% success rate.
  12. That is actually our usual suggestion. See Here...

    That is actually our usual suggestion. See Here for more info
    If however you have DI Server (Enterprise Feature), then contact Pentaho Support.
  13. Try not using the date as part of the key.

    Try not using the date as part of the key.
  14. You can't do it with that step - the simple rules...

    You can't do it with that step - the simple rules of prepared statements prevent it.
    This is why prepared statements are used to help prevent SQL Injection attacks.

    You would need to convert the...
  15. Try using the Modified Java Script Value step...

    Try using the Modified Java Script Value step rather than the Experimental "Script Value" step.
  16. Replies
    3
    Views
    267

    I'm not saying that it does work, but try putting...

    I'm not saying that it does work, but try putting the JAR into the <pdi-install>/lib directory instead of into the <pdi-install>/libext directory that you created.

    Let us know if that works.
  17. That's really not a good way to do it. Use the...

    That's really not a good way to do it.
    Use the "Create file when first row arrives" option.
  18. And I'll support you in that! There is always a...

    And I'll support you in that!
    There is always a balancing act in the system of long-term maintainability (what are you doing, and why are you doing it) vs. efficiency (what is the fastest way to do...
  19. Replies
    7
    Views
    1,134

    Well... That's just messy data at that point,...

    Well... That's just messy data at that point, but...

    You can use the Select Values step to rename the columns so that they are the same in both streams (Lookup succeeded, and Lookup Failed) and...
  20. Replies
    7
    Views
    1,134

    If they are strings, you can use the calculator...

    If they are strings, you can use the calculator step (even back in 3.2) to do String A + String B -> String AB (more specifically... "123" +"4567" becomes "1234567" )
  21. Is splice a variant of Pentaho BI Server? The...

    Is splice a variant of Pentaho BI Server? The Publish Schema function is expecting a full Pentaho BI Server 4 stack, including a Publisher password that has been set. If splice is not a Pentaho BI...
  22. Marabu, I agree with you about...

    Marabu,

    I agree with you about maintainability, but disagree with implementation. (Not like this is new to either of us :P )
    The Fliter Rows clearly shows the logic that is being applied...
  23. Replies
    5
    Views
    583

    Actually... Easiest thing to do is move your...

    Actually...

    Easiest thing to do is move your last two transforms into a wrapper job, and call that job for each row of the results.

    Remember that unlike Transformations, jobs run each step to...
  24. Replies
    7
    Views
    1,134

    What might actually be cleaner would be to define...

    What might actually be cleaner would be to define the lookup to fail if match isn't found, and then define error handling on the step to push those records to another stream to be dealt with.
  25. Replies
    5
    Views
    760

    It's not showing any fields in the Text File...

    It's not showing any fields in the Text File Input definition... You still have to tell PDI how to read the text file - it will then write it back out to a file that it will use in loading to...
  26. Replies
    6
    Views
    741

    You are using an experimental step, when there is...

    You are using an experimental step, when there is a perfectly good, well known script step that is not experimental.
  27. Replies
    6
    Views
    741

    This generally isn't a good sign. Why are you...

    This generally isn't a good sign.
    Why are you putting a script into your transformation if you aren't going to use any of the stream values?
  28. The root of this problem is that Text File Input...

    The root of this problem is that Text File Input is defined to end on a line end.
    As long as you continue to inject CHR(10) into your LISTAGG, Text File Input will not work the way you want it to.
    ...
  29. Replies
    5
    Views
    800

    So clear the group box completely. However, note...

    So clear the group box completely.
    However, note that this isn't really a repeatable transform - your data set would have to match EXACTLY for the outcome to be the same.
  30. Replies
    5
    Views
    800

    This is because your group is mis-defined. ...

    This is because your group is mis-defined.

    What period do you want the Cumulative sum for?
    Note: If you want the Cumulative Sum for the day, and there are no transactions that day, then the...
  31. Replies
    5
    Views
    760

    Should just need the Text File Input and the...

    Should just need the Text File Input and the Oracle Bulk Loader...
  32. Replies
    5
    Views
    760

    You've done a lot of good work here! ...

    You've done a lot of good work here!

    Transforms are a little finicky, in that they have to have an Input step as well as an output step... So you need to have a step defined to read the file that...
  33. Ramireddy, If you had posted your actual file,...

    Ramireddy,

    If you had posted your actual file, instead of a one-line "this is what it's supposed to look like" we would have been able to tell you the problem almost right away.
  34. So... You're injecting Unix line ends into a...

    So... You're injecting Unix line ends into a field, and then wondering why saving that to a file and loading it doesn't work correctly?
  35. Your original post was about having problems with...

    Your original post was about having problems with Text File Input and line endings.

    The only way we can analyze this is by posting a simple version of your transform and your actual text file, but...
  36. Did you try that test file from your Claim2.ktr ?...

    Did you try that test file from your Claim2.ktr ?

    Your text file input (when corrected to point to text.txt ) can't even read the file correctly.
    That will be the first step to getting this...
  37. Replies
    2
    Views
    478

    Have a look at the Row Normalizer. ...

    Have a look at the Row Normalizer.

    http://wiki.pentaho.com/display/EAI/Row+Normaliser

    Try it out, and let us know how you make out.
  38. Somehow in something you are doing in your...

    Somehow in something you are doing in your transform, either in the input data, or through one of the manipulations you do, a null value is getting through to the table output. Oracle won't lie to...
  39. This one I haven't seen before, but I'm betting...

    This one I haven't seen before, but I'm betting that the function doesn't like one of the parameters.

    This means that you have two different elements on the report that are touching. Think about...
  40. It sounds like your file isn't actually a DOS...

    It sounds like your file isn't actually a DOS file. Try the Unix line endings, or the mixed setting.
  41. Honestly, that sounds like a webserver...

    Honestly, that sounds like a webserver configuration issue - instead of executing the PRPT, it is trying to send it to the browser. Since the browser doesn't know what to do with it, it gives the...
  42. The http://community.pentaho.com link? Your...

    The http://community.pentaho.com link?

    Your thread says 5.0.1, but the link downloads 5.1.0 ...
    You can find 5.0.1 on Sourceforge (...
  43. Replies
    2
    Views
    1,219

    The PRPT in the sample is embedded to connect to...

    The PRPT in the sample is embedded to connect to the SampleData dataset, which is stored in the Hypersonic DB.
    You can use the Reporting Step with a report that is designed to connect directly to...
  44. :) All good! You're really getting the...

    :)

    All good!
    You're really getting the details of the software though :D
  45. You should really use the report designer...

    You should really use the report designer designed for your server version.

    That would be PRD5.0
  46. But that's not what your schema shows... (It...

    But that's not what your schema shows... (It shows "LTV_Subtotal", not "LTVSubtotal ")

    That shows why it's important to post actual configurations - what you posted in your original post should...
  47. It's complaining about:

    It's complaining about:
    <Dimension type="TimeDimension" visible="true" foreignKey="date_tk" highCardinality="false" name="dim_date">

    You can't say what the key in the fact table is for a...
  48. If I'm reading your post correctly, you are using...

    If I'm reading your post correctly, you are using spoon to execute a long-running job.

    This long-running job fires off every 20 seconds, and then goes back to sleep.
    You have likely implemented...
  49. Replies
    2
    Views
    2,065

    html code for underline is not

    html code for underline is <u> not <ul>
  50. Replies
    12
    Views
    1,508

    Ok - so I've read a little bit more documentation...

    Ok - so I've read a little bit more documentation on the Job Executor step, and the standard rules don't apply for it.
    They will only run based on the number of rows (they have an inherent "Run for...
Results 1 to 50 of 2496
Page 1 of 50 1 2 3 4