Unknown macro: {scrollbar}

?????? "??????????, ???!"

???????? ?? ???????? ??????? ???????, ? ??? ???????????? ???????? ???????? ?????? ? PDI:

?????? ? ??????????????? Spoon
??????????????
???? ? ????????
???????????????? ??????????
??????????????? ???????? ? ?????????? ?? Spoon
?????????? ?????????????? ?? ???? ????????? ?????????? Pan.

????????

??? ?????? ?????????????? ??? ?????????? ?????? ??????? ? ???? ????? ? ??????? CSV ?????, ? ?????????? ??????? XML ???? ? ???????????? ??? ??????? ?? ???.

???? ?????????? CVS ????? ??? ????????? ?????:

???????,???
??????,????
????????,??????
???????,????
????????,?????
???????,???????
???????,????

?? ??????? XML ???? ????? ????????? ????? ????:

<Rows>
 ?<Row>
       <message>??????????, ????!</message>
  </Row>
 ?<Row>
       <message>??????????, ??????!</message>
  </Row>
 ?<Row>
       <message>??????????, ????!</message>
  </Row>
 ?<Row>
       <message>??????????, ?????!</message>
  </Row>
 ?<Row>
       <message>??????????, ???????!</message>
  </Row>
 ?<Row>
       <message>??????????, ????!</message>
  </Row>
</Rows>

????? ?????????? ??????? ?????????????? ????? ???????? ???? ??????????? ?? ?????.

? ????? ????? ?????????????? ??????? ?? ??????? ????? (Step) ????????? ?????????? (Hop). ?????? ???? ? ???????? ?????????? ???? ??????????? ??????? ????. ?? ???? ???????, ??? ?????????????? ???????????? ?? ????? ??????.

?????????? ?????????

?? ??????? ?????????????? ?????????? ??????? ????? Tutorial ? ???????? ??????????? ??? ????? ?????? ?????. ? ??? ????? ???????? ??? ????? ?? ??????? ???????. ????? ????????? CSV ???? ? ??????????? ???? ???????????, ? ????????? ? ????? Tutorial ??? ?????? list.csv.

?????????? ?? ??????????????

???????????? ?????? ????? ????????? ?? ??? ?????:

???????? ??????????????
?????????? ??????? ?????????????? ?? ????????? ????? ? ?????????
????????? ????? ? ???????????? ? ???????????? ?? ??? ????????

???????? ??????????????

?????? New, ????? ??????? Transformation, ??? ? ???? File ? ??????? New, ? ????? Transformation. ????? ???????? ?????????? ?????? Ctrl-N.
?????? Transformation, ?????? Settings....
??????????? ???? ????????? ?????? ????????? ??? ??????????????. ?? ??? ??????? ??????? ?????????? ?????? ???? ????? ???????? ?????????????? (Transformation name) ? ???????? (Description), ????? ?????? Save.
????????? ?????????????? ? ???????? Tutorial ??? ?????? hello. ??? ???????? ??????? ???? hello.ktr.

?????????? ??????? ?????????????? ?? ????????? ????? ? ?????????

?? ????????? ????????? ??? ??????? ?????? ??????????????. ?? ????? ???????????? ????? ? ?????? ??????? ???????????? ????????? ?????????? ?? ???? (Input) ? ????? (Output) ?????? ??/? ??????? ????????/????????. ?????? ?? ????? ?????????? ???, ????? ??? ?????????? ???????????? ????????? ??? ???????????? ???????, ???????? ??? ?????? ???????????? ?????????? ??? ???????????? ?????? ????????? ??????.

??????? ??? ??????????? ????????????? ???????? ?????? ????? ????? ?????? ?? ????????? ? ?????????. ?????? ???????????? ?? ????????? ???????? ????????? ?? ???? ????????? ?????? (Output Data) ? ????????????? ??? ????????? ?? ???? ???????? ?????? (Input Data). ? ?????? ???????? ???? ?????? ???? ?????? ? ???? ?????????, ?? ????? ??????? ????????? ????????? ??????? ????? ???????? ?? ?????? ????. ??? ????? ??????? ????????? ?????? ????? ???? ??????????? ??? ???????????? ????? ?????? ?? ??????????. ??????????, ?????? ??? ???? ??? ????? ????????? ????????????? ????. ? ????? ??????? ??? ?????? ???????? ???????????? ?????????? ???????? ?????? ?? ?????????? ??????????, ????? ??????? ?????? ????? ????????? ??????.

?????????????? ?????? ????????? ????????? ???????:

???????? ?????? ?? ????? ??????? CSV
???????????? ???????????
????????? ??????????? ? ????? ??????? XML

??? ??????? ?? ???? ??????? ?????????? ???????????? ????????? ????, ???????? ?????????????? ???? ?????:

? ?????? ??????? ???????? ????? ???????? ? ?????? ?????????? ??? ???? ? ??????, ??? ??????????? ?????????????? ????? ???????, ?? ??? ?????? ?? ??????.

??? ???? ????? ?????? ????????? ?????????????? ??????????:

? ???? ?????????? Spoon ??????????? ?????? Steps Palette, ? ??? ???????? ????????? Input.
?????????? ?????? CSV file ? ??????? ??????? ??????.
???????? ????????? Scripting.
?????????? ?????? Modified JavaScript Value ? ??????? ???????.
???????? ????????? Output.
?????????? ?????? XML Output ? ??????? ???????.

?????? ?????????? ???????????? ????? ????? CSV file input ? Modified Java Script Value ?????? ???????:

??????? ?????? ??????? ????.
????????? ?? ?????????? Shift ??????????? ?????? ?? ?????? ??????? ????.
?????????? ????? ????? Modified Java Script Value ? XML Output ???????? ????????.

????????? ????? ? ???????????? ? ???????????? ?? ??? ????????

??? ??????? ?? ????? ????????????? ???? ??????????????? ????????. ? ?????? ???? ??????????????? ????????? ???????????? ?????????????? ??????????? ??????? ???? ????? ? ????????? ? ??????? ??? ?????????. ??? ???? ???????????? ???? (Step Name) ?????????? ??? ??????????? ? ??????????????, ?? ????? ?? ?????????????? ??????????? ????. ???????? ???? (Step Description) ???????? ????????? ???? ?????????? ????, ? ????? ?? ?????? ?? ?????????????? ???????????.

????????? ???? ???? ?? CSV ????? (CSV file input)

?????? ?????? ?? ??? CSV file input.
????????? ???? ???????? ??? ????? ????. ? ??? ?????????? ??????? ????????????, ?????? ? ? ??????? ?????????? ????? ??? ????????.
???????? ???????????? ???????? -??????? ? ????? Step name ?? ????? ??????????????? ??????????? ?? ?????? ??? ?????. ??? ??????? ??????? ??????? ??? ??????? ?????? ????.
? ????? Filename ?????? ???????? ? ???????????? ????????? ?????.
????????: ?????? ?? ???? ????? ????????? ?????? ? ???? ???????? ???????. ??? ?????????? ??????????? ????????????? ? ?????? ???? ??????????, ????? ??? ??????????? ????? ? ?????? ????. ?????????? ????? ???? ??????? ??????? ${name_of_the_variable} ??? ??????? ?? ?????? ? ???? ??????????, ??? ???? ??????? ???????????? ?????? Ctrl-????. ? ?????? ???? ???????????? ???????????????? ?????????? ? ?????????? ???????? ?????????????, ?? ??? ??? ?????????? ?? ??????????, ?? ? ?????? ????? ???? ???????????????? ??????????. ????? ??? ?????????? ???????:
```
${Internal.Transformation.Filename.Directory}
```
????? ?????????? ????????? ????????? ????? ? ??? ????? ?????????? ??????????????:
```
${Internal.Transformation.Filename.Directory}/list.csv
```
????? ??????? ???????? ?????? ?????????? ????? ???????? ? ???????? ? ???? ???? ? ???????? ??? ???? ????????? ??????????????. ????? ?????????????? ????? ?????? ???? list.csv ? ?????? ????????.
??????? ?????? Get Fields ????????? ?????? ???????????? ???????? ? ????????? ?????? ?? ????????? ???. ?????????????? ??? ? ????? ???? ????????? (? ????? ? ????? Header row present ?????? ?????? ???????).

??????????: ?????? Get Fields ?????????? ?? ?????? ????? ????? ? ???????? ? ???? ????????. ??? ?????????? ??? ???????? ????????? ?????? ?? ??????? ?????????? ??? ?? ?????????? ?????. ??? ???? ??? ??? ????? ????????? ???????, ?? ??? ?????? ????????? ????? ??????????? ??? ????????? ????????? ????? ? ??? ???? ?????????????? ????????????? ?? ????.
?????? ????????? ???????? ???????????? ???????? ?? ???. ??? ??????? ??????? ??? ??? ? ?:
????? ??????? ? ????? Lazy conversion?.

??????????: ??? ?????? ? ??????? ??????????? ????? ????????? ????? ????? ????? ????????? ????????? ?????? ????? ???? ?????? ?? ?????? ? ????? File encoding ??????????????? ????????.
?????? Preview ? ??????????????, ??? ???? ????? ????????? ????????. ?????????? ?? ????? ?????? ?????? ??????????? ? ??????????? ????.
?????? OK ??? ?????????? ? ???????? ???????? ??? ???? CSV file input.

???????????? ???? JavaScript ??? ??????????? ???????? (Modified JavaScript Value)

?????? ?????? ?? ??? Modified JavaScript Value.
????????? ???? ???????? ??? ????? ??. ?????? ???? ?????????? ?? ??????????? ???????????? ????????? ???????????? ???? ?? ????? JavaScript. ??? ?????????? ??? ???????? ????? ?? ???? ??????, ????????? ??????????? "????????, " ? ?????? ?? ????.
??????? ?????? ??? ???????? ???????????.
??????????? ??????? ???? ???????? ????????????? ??? ????? ??. ? ????? ?????? ??????????? ????? ????????? ??? ????????????? ??? ????????? ???? ???????. ??? ???? ????? ?????? ???????????? ??? ?????? Input fields ? Output fields ??????? ? ?????????????. ??? ??????? ??????? ??????????? ??? ????: ??? ? ?. ?????? ????????? ???:
```
var message = '??????????, ' + ???.getString() + "!";
```
????????: ??????? ?.getString() ????? ?????? ??????? ??? ?????? ?????? ?? ?????? ???? ? ?????????????? ?????? ???????.
? ?????? ????? ???? ?????????? ?????? ??????????? ? ?????????? ?????????? ??????? ??????????. ? ?????? ??????? ??????? ?????????? message. ??? ??? ???????? ?????? ?????????? ?????? ???? ???????? ? ???? ? ??????????? ??????????????, ???????????? ?????? ?????????? ??????? ??????? ? ??????. ????????? ????? ????? ????????? ???:

????????: ?? ??????? ?????? ?????????? ?????? ??????? ? ??????????? ?????????? PDI, ??? ?? ???? ? ????.

??????????: ??? ????????????? ????????? ???????? ? ????????? ????????? ?????? PDI ??????? ????? Compatibility mode? ???????? ????????.
?????? OK ??? ?????????? ? ???????? ???????? ??? ???? Step Modified Script Value.
??????? ?????? ?????? ??? ?????????????????? ??. ?? ?????? ???? ?????????? ?????????? ?????? ???? ? ?????? ????? (Input Field) ? ???????? ?? ???? ?????? ? ????????? ????? (Output Field). ???????? ?? ????????? ?? ?????? ????. ??????? ?? ???????? ?????? ???. ?????? ??? ?????????? ????????????? ???????? ??????????? ??????. ?? ? ?????? ???????, ???????? ??????????? ?????? ?? ???????? ??? ????????? ?????????? ?????? ???? ????????? ????. ?? ???? ????, ??????? ????????? ???????? ? ???????? ?????, ???????? Calculator. ????? ???? ???? ???????????? ?????????? ? ?????????????? ??????????? ??????, ? ?????????? ??????? ?? ?????? ?????? ?????, ???????? Group by.
?????? ?????? ??????? ???? ??? ??????? ? ???????????? ????.
??????? Show Input Fields. ? ??????????? ???? ????? ??????? ???????? ???? ????? ? ?, ?????????? ?? ?????????? ????.
??????? Show Output Fields. ? ??????????? ???? ?????, ??? ? ??????????? ???? ???????? ??? ?????????, ?? ?????????? ???? ????? ???? message.

???????????? ???? ????? ? XML ???? (XML Output)

?????? ?????? ?? ??? XML Output. ????????? ???? ??? ??????? ???? ????. ?? ?????? ???? ???????????? ????? ???????????? ? ???????? ????? ? ??????????? ?????????? ??????????????. ????? ???????? ????, ??????? ?????????? ????????? ? ?????? ????. ??? ?????? ????? ???? ????????, ??? ??? ???? ????????? ??????? ????, ??? ? ????????? ???? ?? ??????.
?? ??????? File ?????? ???????? ???????? ?????? ??????????? ??? ??????? ????.

? ????? File ??????:

${Internal.Transformation.Filename.Directory}/hello.xml

??????? ?? ??????? Fields ? ?????? ?????? Get Fields, ? ?????? ????? ???????? ??? ???? ??? ????. ??? ?????????? ????? ?????????? ?????? ???? message, ??????? ?????????? ??????? ???? ? ? ???????.
?????? OK ??? ?????????? ? ???????? ???????? ??? ???? XML Output.
????????? ??????????????.

???????? ??????

??? ?????????? ?????????????? ??????????? ??? ???? ??????????? ??????????. ??- ????, ??? ?????????????? ????????? ?????? ??????????, ???????? ?????????? ????????? ????? ???????????. ?????? ??????????? ?????? ?????? ?????????? ?? ????????? ???? ?? ?????? ????????? ?????? ??????. ?????????? ?? ???????? ??? ??????????? ??????????????, ??? ??? ??? ????? ?????? ?????? ?? ?????????? ??????????.

????????? ??????? "??????, ???!" ??????????? ?????????. ?????????????? ????????? ?????? ?? ???????? ?????, ? ??????? ???? JavaScript ????????? ??????????? ??? ??????? ?? ????? ??????, ? ? ????? ?????????? ????????? ???????????? ? ???????? ????. ? ?????? ????????? ??????? ????? ????????? ????? ? ???????, ??????? ???????? ??????????? ?????????? ????? ??????. ?????? ???? ????? ????? ???, ????? ???? ??? ???????????? ? ???????? ????, ?????? ???????? ?????? ??? ??????????????.

????????, ???????? ? ??????????

????? ??????????? ??????????????, ?????????? ????????? ???????????? ????????????, ??????? Transformation ? ?????? Verify. Spoon ???????? ????????? ??????????????, ?????? ???????????? ???? ? ?????????????? ?????. ???? ?????????????? ?????? ???????? ??????? (? ??? ?????? ???? ?????? ???, ???? ????????? ?????? ??????????), ??? ?????? ??? ??? ???????????????? ?????????.
???????? ??? ???????? ???????????, ??????? Transformation ? ????? ?????? Preview. ?????? ???????? ???? ????:
??? ????? ?????? Spoon ?????????? ?????????????? ??????????? ?????????? ?????????? ?????????? ??. ?????? ?????? QuickLaunch. ????? ???? ???????? ???? ? ??????????????? ??????????? ????????? ? ?????????? ?????????? ???? ?????? ???????????. ???? ????????? ????????????? ????????????? ???????????, ?????? ??? ????? ??? ?????????? ??????????????.
??????? Transformation ? ????? ?????? Run.
???????? ???? ? ??????? ????? ?????? ????????? ?????????? ? ???????????? ??????????????. ?????? ?????? Launch.
? ?????? ????? ???? ?????????? ???????? ???? ? ??????????? ?????????. ?? ???????? ?????????? ?????????? ? ?????????? ???????? ??????????????.

?? ??????? Step Metrics ?????????? ?????????? ???????? ?????????????? ?? ?????. ?????????? ???????? ???????? ?? ????????? ???????:

Read: ?????????? ????? ?????????? ? ?????????? ?????.
Written: ?????????? ????? ?????????? ? ??????? ???? ?? ?????????.
Input: ????? ????? ??????????? ?? ????? ??? ??????? ???? ??????.
Output: ????? ????? ?????????? ? ???? ??? ??????? ???? ??????.
Errors: ????? ?????? ????????? ??? ??????????. ???? ???????? ?????? ?????? ?????????? ???????.

?? ??????? Logging ????????? ?????? ??????????. ? ??? ?????????? ????????? ?????????? ? ?????????? ?????????????? ?? ?????. ???? ???????? ????????? ?????? ??????????, ?? ????? ??????? ????????????? ?????????? ?????. ??? ???????? ?????????? ?????????????? ? ?????? ?????? ??????? ????? ????????? ?????????:

Spoon - The transformation has finished!!

????? ??? ???????? ?????????? ?????????????? ????? ?????? ???? hello.xml, ?????????? ????????? ??? ?????????? ?? ???????????? ?????????? ???????????? ??????.

Pan

Pan ??? ?????? ?????????? ?????????????? ?? ????????????? ????. ??? ?????? ???????????? ????? ?????? pan.bat ? Windows ??? pan.sh ?? ?????? ??????????, ??? ??????????? ? ???????????? ????????. ???? ?????? ??????????? ??? ?????????? ?? ????? ????????? ?????? ????????? ?????????? ??? ?????????? Pan.

????????? ?????????????? ????? ????????? ????????:

Pan /file <Jobs_path>/hello.ktr /norep

/norep ??????? ?? ???????? ??????????? Spoon ? ???????????.
/file ????????? ?? ??? ????? ??????????? ??????????????.
<Jobs_path> ?????? ???? ? ???????? ? ????????:

C:/Pentaho/Tutorial

???

/home/PentahoUser/Tutorial

????????? ????????? ??????? ????? ???????????? -???????.

????? ??????? ?????? ??????? ?????????????? ????? ????????? ????? ???, ??? ? ??? ??????? ????? Spoon. ? ?????? ?????? ????? ????? ??????? ?? ????? ??? ? ???? (?? ??? ???????) ?????? ??????????. ?????? ??????? ????? ?????????? ?? ????, ??? ??? ??????????? ? ??????????? ????????, ??? ???? ?????????? ?????????? ????? ???????????.

03. Hello World Example (ru)