Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 15 Next »

Unknown macro: {scrollbar}

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

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

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

????????

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

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

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

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

- <Rows>
  - <row>
        <msg>??????????, ????!</msg>
    </row>
  - <row>
        <msg>??????????, ??????!</msg>
    </row>
  - <row>
        <msg>??????????, ????!</msg>
    </row>
  - <row>
        <msg>??????????, ?????!</msg>
    </row>
  - <row>
        <msg>??????????, ???????!</msg>
    </row>
  - <row>
        <msg>??????????, ????!</msg>
    </row>
  </Rows>

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

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

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

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

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

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

  1. ???????? ??????????????
  2. ?????????? ??????? ?????????????? ?? ????????? ????? ? ?????????
  3. ????????? ????? ? ???????????? ? ???????????? ?? ??? ????????

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

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

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

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

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

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

  • ???????? ?????? ?? ????? ??????? CSV
  • ???????????? ???????????
  • ????????? ??????????? ? ????? ??????? XML

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

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

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

  1. ? ???? ?????????? Spoon ??????????? ?????? Steps Palette, ? ??? ???????? ????????? Input.
  2. ?????????? ?????? CSV file ? ??????? ??????? ??????.
  3. ???????? ????????? Scripting.
  4. ?????????? ?????? Modified JavaScript Value ? ??????? ???????.
  5. ???????? ????????? Output.
  6. ?????????? ?????? XML Output ? ??????? ???????.

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

  1. ??????? ?????? ??????? ????.
  2. ????????? ?? ?????????? Shift ??????????? ?????? ?? ?????? ??????? ????.
  3. ?????????? ????? ????? Modified Java Script Value ? XML Output ???????? ????????.

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

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

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

  1. ?????? ??????? ?? ??? CSV file input.
  2. ????????? ???? ???????? ??? ????? ???? ????. ???? ?????????? ??????? ????????????, ?????? ? ? ??????? ?????????? ????? ??? ????????.
  3. ???????? ???????????? ???????? -??????? ? ???? Step name ?? ????? ??????????????? ??????????? ?? ?????? ??? ?????. ??? ??????? ??????? ??????? ??? ??????? ?????? ????.
  4. ? ???? Filename ??????? ???????? ? ???????????? ????????? ?????.

    ????????: ?????? ?? ???? ????? ????????? ?????? ? ???? ???????? ???????. ??? ?????????? ??????????? ????????????? ? ?????? ???? ??????????, ????? ??? ??????????? ????? ? ?????? ????. ?????????? ????? ???? ??????? ??????? ${name_of_the_variable} ??? ??????? ?? ?????? ? ???? ??????????, ??? ???? ??????? ???????????? ?????? Ctrl-????. ? ?????? ???? ???????????? ???????????????? ?????????? ? ?????????? ???????? ?????????????, ?? ??? ??? ?????????? ?? ??????????, ?? ? ?????? ????? ???? ???????????????? ??????????. ????? ??? ?????????? ???????:

    ${Internal.Transformation.Filename.Directory}
    

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

    ${Internal.Transformation.Filename.Directory}/list.csv
    

    ????? ??????? ???????? ?????? ?????????? ????? ???????? ? ???????? ? ???? ???? ? ???????? ??? ???? ????????? ?????????????. ????? ?????????????? ????? ?????? ???? list.csv ? ?????? ????????.

  5. ??????? ?????? Get Fields ????????? ?????? ???????????? ???????? ? ????????? ?????? ?? ????????? ???. ?????????????? ??? ? ????? ???? ????????? (? ????? ? ???? Header row present ?????? ?????? ???????).

    ??????????: ?????? Get Fields ?????????? ?? ?????? ????? ????? ? ???????? ? ???? ????????. ??? ?????????? ??? ???????? ????????? ?????? ?? ??????? ?????????? ??? ?? ?????????? ?????. ??? ???? ??? ??? ????? ????????? ???????, ?? ??? ?????? ????????? ????? ??????????? ??? ????????? ????????? ????? ? ??? ???? ?????????????? ????????????? ?? ????.

  6. ?????? ????????? ???????? ???????????? ???????? ?? ???. ??? ??????? ??????? ??? ??? ? ?:
  7. ????? ??????? ? Lazy conversion?

    ??????????: ??? ?????? ? ??????? ??????????? ????? ????????? ????? ????? ????? ????????? ????????? ?????? ????? ????, ?????? ?? ?????? ? ???? File encoding ??????????????? ????????.

  8. ?????? Preview ? ??????????????, ??? ???? ????? ????????? ????????. ?????????? ?? ????? ?????? ?????? ??????????? ? ??????????? ????.
  9. ?????? OK ??? ?????????? ???????? ???? CSV file input.
  • No labels