Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: To transform sql into flow in pentaho data integration

  1. #1
    Join Date
    Nov 2016
    Posts
    3

    Default To transform sql into flow in pentaho data integration

    Please,To transform sql into flow in pentaho data integration?

  2. #2
    Join Date
    Jun 2012
    Posts
    5,534

    Default

    If you don't get the answers you expect, try a better description of your problem.

    If your question is too unspecific, we usually refer to the books listed in the sticky posts.
    So long, and thanks for all the fish.

  3. #3
    Join Date
    Nov 2016
    Posts
    3

    Default

    <br class="Apple-interchange-newline"><div id="inner-editor"></div>








    [COLOR=rgba(0, 0, 0, 0.541176)]127/5000




    [/COLOR]
    The idea was with the query, below the possibility of there being some wizard that transformed it to the correct components in the PDI.

    SELECT po.column1 'A'
    ,p.column1'B'
    ,p.column1 'F/J'
    ,a.column1 'A'
    ,CASE WHEN a.column1 = 'A' THEN 'A'
    WHEN a.column1 = 'B' THEN 'A'
    WHEN a.column1 = 'D' THEN 'A'
    WHEN a.column1 = 'E' THEN 'A'
    WHEN a.column1 = 'F' THEN 'A'
    WHEN a.column1 = 'I' THEN 'A'
    WHEN a.column1 = 'X' THEN 'A'
    ELSE 'N/I' END 'A'
    ,p.column1 'A'
    ,pf.column1 'CPF/CNPJ'


    ,CONVERT(CHAR(10),pf.column1,103) as 'A'
    ,CONVERT(CHAR(10),a.column1,103) 'A'





    ,(
    SELECT SUM(ld.column1)
    FROM table7 ld
    WHERE ld.column1 IN (SELECT column1 FROM table8)
    AND ld.column1 IN (SELECT c.column1 FROM table8 c WHERE c.column1 = p.column1 AND c.column1 = a.column1)
    AND YEAR(ld.column1) = 2016
    AND MONTH(ld.column1) = 12
    ) 'A'


    FROM table1 a
    ,table2 p
    ,table3 pf
    ,table4 po
    WHERE p.column1 = pf.column1
    AND a.column1 = p.column1






  4. #4
    Join Date
    Jun 2012
    Posts
    5,534

    Default

    I can imagine you want to access the rows specified by that SELECT statement: A Table-Input step is used for this.
    But a single step isn't a very impressive dataflow, yet.
    What else do you want to do with the data?
    So long, and thanks for all the fish.

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.