HgIS

Správa a analýza dat o životním prostředí
Environmental data management and analysis

User Tools

Site Tools


en:cheatsheet

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
en:cheatsheet [2019-10-31]
Kamil Nešetřil
en:cheatsheet [2019-10-31] (current)
Kamil Nešetřil
Line 32: Line 32:
 | {{ :​pdi21_rowdenorm.png?​40&​nolink }} | [[https://​help.pentaho.com/​Documentation/​8.3/​Products/​Row_Denormaliser|Row denormaliser]] ​           | //Key// – input categories.\\ ''​The key field''​ (name of the input colums with categories),​\\ ''​Group field''​ (what identifies the whole future row – e.g. //​filename//​),​\\ ''​Target fieldname''​ = ''​Key value''​ (single categories),​\\ ''​Value fieldname''​ (name of the input column with values)\\ [[en:​resources#​excel_add-ins_for_data_processing|More:​ Microsoft Power Query for Excel]]| | {{ :​pdi21_rowdenorm.png?​40&​nolink }} | [[https://​help.pentaho.com/​Documentation/​8.3/​Products/​Row_Denormaliser|Row denormaliser]] ​           | //Key// – input categories.\\ ''​The key field''​ (name of the input colums with categories),​\\ ''​Group field''​ (what identifies the whole future row – e.g. //​filename//​),​\\ ''​Target fieldname''​ = ''​Key value''​ (single categories),​\\ ''​Value fieldname''​ (name of the input column with values)\\ [[en:​resources#​excel_add-ins_for_data_processing|More:​ Microsoft Power Query for Excel]]|
 | {{ :​pdi17_setvar.png?​40&​nolink }} | [[https://​wiki.pentaho.com/​display/​EAI/​Set+Variables|Set Variables]] ​                                                                                  | In other tranformations this variable can be used as a variable of as a parameter. Parameter can have a default value (taken into effect if the variable is not defined). ​     | | {{ :​pdi17_setvar.png?​40&​nolink }} | [[https://​wiki.pentaho.com/​display/​EAI/​Set+Variables|Set Variables]] ​                                                                                  | In other tranformations this variable can be used as a variable of as a parameter. Parameter can have a default value (taken into effect if the variable is not defined). ​     |
-| {{ :​pdi18_etlmetadatainjec.png?​40&​nolink }} | [[https://​help.pentaho.com/​Documentation/​8.3/​Products/​ETL_metadata_injection|ETL Metadata Injection]] ​   | To control the transformations. Combine with ''​Transformation Executor''​.\\ [[https://​support.pentaho.com/​hc/​article_attachments/​360003638211/​Guidelines%20-%20Metadata%20Injection.pdf|Best practices]].\\ [[http://​sandbox.kettle.be/​wordpress/​index.php/​2011/​02/​25/​parse-nasty-xls-with-dynamic-etl/​|Matt Casters: Parse nasty XLS with dynamic ETL]] \\ At the end of the [[http://​kettle.bleuel.com/​2016/​04/​14/​pentaho-6-1-part-2/​|article]] is an example including source codes. \\ Alternative:​ run the transformation in job and check //Execute every input row//.|+| {{ :​pdi18_etlmetadatainjec.png?​40&​nolink }} | [[https://​help.pentaho.com/​Documentation/​8.3/​Products/​ETL_metadata_injection|ETL Metadata Injection]] ​   | To control the transformations. Combine with ''​Transformation Executor''​.\\ [[https://​support.pentaho.com/​hc/​article_attachments/​360003638211/​Guidelines%20-%20Metadata%20Injection.pdf|Best practices]].\\ [[http://​sandbox.kettle.be/​wordpress/​index.php/​2011/​02/​25/​parse-nasty-xls-with-dynamic-etl/​|Matt Casters: Parse nasty XLS with dynamic ETL]] \\ At the end of the [[http://​kettle.bleuel.com/​2016/​04/​14/​pentaho-6-1-part-2/​|article]] is an example including source codes. \\ Alternative:​ run the transformation in job and check //Execute every input row// – [[https://​www.youtube.com/​watch?​v=A8-oQHFi4VA|video]].|
 | {{ :​pdi19_transformexe.png?​40&​nolink }} | [[https://​help.pentaho.com/​Documentation/​8.3/​Products/​Transformation_Executor|Transformation Executor]] ​ | Every row runs a new transformation. ​                                                                                                                                                                                                                                                                                                                                                        | | {{ :​pdi19_transformexe.png?​40&​nolink }} | [[https://​help.pentaho.com/​Documentation/​8.3/​Products/​Transformation_Executor|Transformation Executor]] ​ | Every row runs a new transformation. ​                                                                                                                                                                                                                                                                                                                                                        |
 | {{ :​cheatsh01.png?​40&​nolink }}  | [[https://​wiki.pentaho.com/​display/​EAI/​Add+Constants|Add Constants]] ​                                                                                    ​| ​                                                                                                                                                                                                                                                                                                                                                                             | | {{ :​cheatsh01.png?​40&​nolink }}  | [[https://​wiki.pentaho.com/​display/​EAI/​Add+Constants|Add Constants]] ​                                                                                    ​| ​                                                                                                                                                                                                                                                                                                                                                                             |
en/cheatsheet.txt · Last modified: 2019-10-31