Thread: To transform sql into flow in pentaho data integration

1. Junior Member
Join Date
Nov 2016
Posts
3 To transform sql into flow in pentaho data integration

Please,To transform sql into flow in pentaho data integration? 2. Senior Member
Join Date
Jun 2012
Posts
5,534 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. 3. Junior Member
Join Date
Nov 2016
Posts
3 <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. Senior Member
Join Date
Jun 2012
Posts
5,534 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?  Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•