Hitachi Vantara Pentaho Community Forums
Results 1 to 8 of 8

Thread: preview vs run

  1. #1
    Join Date
    Jul 2007
    Posts
    8

    Question preview vs run

    I have a proble, when launch the execution of one mine trasformatio in preview the result is corrected, but when I effectively execute it with the button run transformations the result is not the same.

    I have a txt input, a simple sort and a txt output. The input and output are in the same format:
    -409.770|"ITL "|1936.264246|-793423.000
    Number Format=0.000 Length=18 Precision 3 Decimal=.
    String Lenght=4
    Number Format=0.000000 Lenght=11 precision 6 Decimal=.
    Number Format=0.000 Lenght=18 precision 3 Decimal=.

    When I execute the transformations in preview it's ok but when I execute the transformations in run the format in output becomes:
    -4097700.000|"ITL "|1936264246.000000|-793423000.000

    What I can do?
    Sorry for my English

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

    Default

    in v3.0 or v2.5 ... In v2.5 the preview values are not the same as the actual output (the preview doesn't use formatting).

    Forget about the preview... put enough formatting in your transformation to get the right output.

    Regards,
    Sven

  3. #3
    Join Date
    Jul 2007
    Posts
    8

    Default

    I have tried to do it but I don't understand which error I have done.

    I don't understand what is the error in my formatting?

    I have tried various possibilities but they are to the first experiences with kettle can you help me

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

    Default

    Attach the transformation and e.g. that 1 line with you have problems with, and which version are you using?

    Regards,
    Sven

  5. #5
    Join Date
    Jul 2007
    Posts
    8

    Default

    I use kettle 2.5
    My transformation is Example.ktr
    My txt document is Documenti.txt
    and I would want this result DocuSortOk.txt
    but kettle give my this DocuSortError.txt

    thanks for the aid

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

    Default

    Remove the format on the numbers in the text input field and you'll be ok.

    Regards,
    Sven
    Attached Files Attached Files

  7. #7
    Join Date
    Jul 2007
    Posts
    8

    Default

    I have try but the result isoutput.txt
    and notDocuSortOk.txt

    If you open whit notepad you can see
    In your transformation the output is(row 4):
    "10"|"CL"|"1999"|"RC"| 0010607,00|"001000112"|"10"|"CL"|"C10002:EURO "|"9032467"|19991231,00|"N.C. x diff. prezzo "|"EURO"| 000000000991600,000|"ITL "| 1936264623,000000| 000001920000000,000|"A"| 19991231,00|" "|" "| 19991231,00|"1"|"E"|"1"|" "|" "|000000,00|1|"EURO"|"EURO"

    I want this (row 4):
    "10"|"CL"|"1999"|"RC"|10607|"001000112"|"10"|"CL"|"C10002:EURO "|"9032467"|19991231|"N.C. x diff. prezzo "|"EURO"|991.600|"ITL "|1936.264623|1920000.000|"A"|19991231|" "|" "|19991231|"1"|"E"|"1"|" "|" "|0|1|"EURO"|"EURO"

    I don't have problems with the string but the number are not like I would want.

    It's my version: kettle 2.5.0 Build version 25002


    i have find the problem is in input but the preview is non very good.
    it has tricked to me

    thanks however.
    Perez
    Last edited by perez.pdf; 07-26-2007 at 09:16 AM.

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

    Default

    Ok... the 3.0 will have a better preview ;-)

    Regards,
    Sven

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.