Differences
This shows you the differences between two versions of the page.
Both sides previous revision Previous revision | |||
lesson_7 [2020/02/11 21:51] hermann |
lesson_7 [2020/02/19 16:44] argemiro |
||
---|---|---|---|
Line 27: | Line 27: | ||
* Add a [[Set Table By Key]] to the sketch, assign the output of [[Add Table Column]] to the __Subtable__ input port of [[Set Table By Key]] and the [[Load Table]] with ''IBGE_crop_information_uptated.csv'' to the __Table__ port. In the Functor Editor window, enter ''1999'' as the key identifying the sub-table that will be updated or inserted. Additionally, toggle the __Ignore Column Names__ flag in the Functor Editor Window. | * Add a [[Set Table By Key]] to the sketch, assign the output of [[Add Table Column]] to the __Subtable__ input port of [[Set Table By Key]] and the [[Load Table]] with ''IBGE_crop_information_uptated.csv'' to the __Table__ port. In the Functor Editor window, enter ''1999'' as the key identifying the sub-table that will be updated or inserted. Additionally, toggle the __Ignore Column Names__ flag in the Functor Editor Window. | ||
\\ | \\ | ||
- | * To save the result to a file, place a [[Save Table]] on the sketch, browse to ''Guidebook_Dinamica_5\Models\Set_2\basics\'' and write the file name (e.g. ''IBGE_crop_information_complete''). | + | * To save the result to a file, place a [[Save Table]] on the sketch, browse to ''\Guidebook_Dinamica_5\Models\add_table_column_set_table_by_key'' and write the file name (e.g. ''IBGE_crop_information_complete''). |
\\ | \\ | ||
* Click on the layout tool Execute Layout. Your final model should be similar to the one below: | * Click on the layout tool Execute Layout. Your final model should be similar to the one below: | ||
Line 71: | Line 71: | ||
\\ | \\ | ||
\\ | \\ | ||
- | * To save the result to a file, edit [[Save Table]], browse to ''GuideBook_Dinamica_5\Models\Set_2\basics\ Get_Table_from_Key'' and write the file name (e.g. IBGE_crop_information_update). | + | * To save the result to a file, edit [[Save Table]], browse to ''\Guidebook_Dinamica_5\Models\add_table_column_set_table_by_key'' and write the file name (e.g. IBGE_crop_information_update). |
\\ | \\ | ||
\\ | \\ |