Hitachi Vantara Pentaho Community Forums

Search Forums:

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

Search Forums: Search took 0.02 seconds.

  1. Replies
    9
    Views
    745

    Ok, ok, I´m sorry, I thought it was one of them...

    Ok, ok, I´m sorry, I thought it was one of them only, and not both at the same time, "+" and "-"... :)

    Thank you so much!
  2. Replies
    9
    Views
    745

    Ok, Thanks marabú! But can I fix manually the...

    Ok, Thanks marabú!

    But can I fix manually the sign? Is there any carachter in order to control the sign? Just trying to avoid to fix "+" or a "-" manually. Something like "S00000000,00"...
    ...
  3. Replies
    9
    Views
    745

    Ok, I see, But the point is that I don´t find...

    Ok, I see,

    But the point is that I don´t find this format in order to fix it and grant the right treatment for something like "+7575775"...

    19103
  4. Replies
    9
    Views
    745

    Hi DepButi, Actually the fact is that I´m...

    Hi DepButi,

    Actually the fact is that I´m recieving something like "+06349". In the technical specifications, it´s suposed to be NUMBER(5,0). But when I run the transformation, my file has "+" ...
  5. Replies
    9
    Views
    745

    How to fix number(x,y)

    Hi,

    I would like to fix in a transformation a concrete type and length (e.g, number(15,2), with +/-). But using Text File Input step (Fixed file),
    "fields" tab, "Format" column, I don´t see the...
  6. Fixed! Thanks so much Depbuti & Marabú! In the...

    Fixed! Thanks so much Depbuti & Marabú! In the case of a plane email, it is clear!

    But as you know, requirements sometimes are changing every half an hour,...or even less...XD

    In case of we...
  7. Mmmmm... I tried sending to myself two mails,...

    Mmmmm... I tried sending to myself two mails, both with attachments, and one with "loan" in the body and other one without "loan". And the job processes both mails and take both attachments... :S
  8. I tried like this, a simple transformation, but...

    I tried like this, a simple transformation, but didn´t differenciate between mails with "loan" in the body and not...

    Screenshot attached.

    18940

    Should I need to use " .* " ?
  9. Thanks for your help, DepButi, Marabú, ...

    Thanks for your help, DepButi, Marabú,


    However, I´m so sorry, but I don´t get the point about the
    "subject (or body) searched via SubjectTerm" :S
  10. I just need to check the body, check if there is...

    I just need to check the body, check if there is the word LOAN, and then, move the attachment included in that mail to a folder called LOAN, whatever it is this attachment, without matching them, no...
  11. OMG! Definitely I missed many many things...

    OMG! Definitely I missed many many things Depbuti! I will try to arrange some workflow with this excellent help you gave me!

    Moltíssimes gràcies company!
  12. Maybe only checking the email body will be...

    Maybe only checking the email body will be enough! :)
  13. [LEFT][COLOR=#222222][FONT=Verdana] ...

    [LEFT][COLOR=#222222][FONT=Verdana]

    Pufff...molt! :S




    So should I fix the field "Fields to evaluate" as "body field"? I cannot fix any value with the drop-down list, it´s empty. And btw,...
  14. [/FONT][/COLOR][/LEFT] How can I do it? Which...

    [/FONT][/COLOR][/LEFT]

    How can I do it? Which step? Sorry but I´m quite lost...


    [LEFT][COLOR=#222222][FONT=Verdana]

    E.g, receiving an standard email where the words we are looking for are...
  15. Thanks DepButi! A part from that, the...

    Thanks DepButi!

    A part from that, the transaction/operation I want to do would be based in a kind of OCR: maybe reading directly the email´s body message and if there´s a concrete word there, send...
  16. Ok, thanks Marabu for your help!

    Ok, thanks Marabu for your help!
  17. [/FONT][/COLOR][/LEFT] Thanks [LEFT]Marabú for...

    [/FONT][/COLOR][/LEFT]

    Thanks [LEFT]Marabú for your answer. Sorry, but I don´t get the point. Why? Which is the relationship between the name of the file and target folders?
    ...
  18. Read an unknown excel file as an email attachment

    Hi,

    I want to arrange a system where I will recieve mails and then will check their attachments (mostly Excel files). As a result I will send another email, or anyway, execute another action,...
  19. [/FONT][/COLOR][/LEFT] Well, I would need the...

    [/FONT][/COLOR][/LEFT]

    Well, I would need the name of the attachments, or maybe the Subject, or maybe some concrete word in the email´s Body...I consider all these different scenarios...


    ...
  20. Sorry, which step exactly? Can I check and use a...

    Sorry, which step exactly? Can I check and use a row from an attachment? and can I do it with different formats (.xls, .PDF, etc...)?

    Thanks in advance DepButi!
  21. Sending an email according some condition

    Hi!

    I would like to arrange a transformation in order to send different emails to different email addresses, according to the values of concrete fields (e.g. the value of a cell in a .xls...
  22. Thanks rajeshcrec! So which field will be...

    Thanks rajeshcrec! So which field will be incremented then?
  23. Yes DepButi, :) it´s what I will do, probably......

    Yes DepButi, :) it´s what I will do, probably...



    Yes, I will fix it using a different set of folders, and distributing them (pending, processed, not processed), also controlling the mail...
  24. Hi Marabú, I´m trying to arrange my...

    Hi Marabú,

    I´m trying to arrange my transformation with the "Add value fields changing sequence" step, and I don´t know why but something is going wrong...cannot do the increment fixing "start at...
  25. Replies
    0
    Views
    696

    Incremento de variables

    Hola,

    Me surge una duda con respecto a un Job que estoy intentando implementar. Estoy intentando leer mail y extraer los adjuntos existentes, para posteriormente identificar cada adjunto/s con su...
  26. Thank you for your help, rajeshbcrec! I will try...

    Thank you for your help, rajeshbcrec! I will try to fix it, with one of the options you suggested me!

    Kind regards.
  27. The point is that at Job level I only can use Set...

    The point is that at Job level I only can use Set Variables (and not Get Variables)
  28. Thanks for your answer marabú! Do you mean...

    Thanks for your answer marabú!

    Do you mean "Add value fields changing sequence"?

    The pioint is that the final objective is to implement a dataflow for classify different attachments. I´m...
  29. Hi mtucker! And thank you very much for your...

    Hi mtucker!

    And thank you very much for your answer! I will have a look to this option!

    Kind regards!
  30. How to pass a variable and increment it without using User Defined Java Class

    Hi,

    I would like to know if it's possible to pass a variable/parameter, increment it ("var=var+1"), and get it in the following step, without using User Defined Java Class step, without using any...
  31. The point is that I´m trying to create different...

    The point is that I´m trying to create different folders for every new attachment arrived to an INBOX in my attach_cond Job, where I can find the Get emails from POP (retrieving attachments and...
  32. In which step/part concretely? Where and how...

    In which step/part concretely?

    Where and how exactly? Is it correct my schema?

    Thanks in advance!
  33. Hi Ana, And thanks for your early response :)...

    Hi Ana,

    And thanks for your early response :)

    I fixed the Get emails from POP like this (please see attachment).

    Can you please provide me a few more details about it? :) I´m a beginner as a...
  34. Create one folder for each retrieved attachment

    Hi!

    I´m trying to arrange a Job in order to retrieve some attachments from different email addresses (saving message content & attachment). The point is that didn´t find the way to store the...
  35. Replies
    2
    Views
    483

    Hi gutlez, Thank you very much for your...

    Hi gutlez,

    Thank you very much for your answer! I found this step with another name, cause I have a version half in spanish and half in english, and with a different graphic symbol, not familiar...
  36. Replies
    2
    Views
    483

    Alternatives of Get System info

    Hi,

    I want to use the Batch_ID within a transformation and get it in the final part of a job. Doing right click < Properties < Settings tab I check the checkbox Pass batch ID? and I have read in...
Results 1 to 36 of 37
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

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