Differences
This shows you the differences between two versions of the page.
Both sides previous revision Previous revision | Next revision Both sides next revision | ||
lesson_7 [2020/02/10 21:45] argemiro |
lesson_7 [2020/02/10 21:46] argemiro |
||
---|---|---|---|
Line 4: | Line 4: | ||
====LESSON 7: Creating a new column and retrieving a data column from tables==== | ====LESSON 7: Creating a new column and retrieving a data column from tables==== | ||
\\ | \\ | ||
- | * To create a new column in a given table we must open all the files that will be used to retrieve data from. Click on the Input/Output tab from the library window and grab three **Load Lookup Table** Functors and one **Load Table** placing them on the sketch. Open the **Load Lookup Table** functors and load the files ''1999_production_value.csv'', ''1999_harvested_area.csv'' and ''1999_production.csv'' from the folder ''Guidebook_Dinamica_5\Database\Database\Tables\''. Next, open **Load Table** and load ''IBGE_crop_information_uptated.csv''. | + | * To create a new column in a given table we must open all the files that will be used to retrieve data from. Click on the Input/Output tab from the library window and grab three **Load Lookup Table** Functors and one **Load Table** placing them on the sketch. Open the **Load Lookup Table** functors and load the files ''1999_production_value.csv'', ''1999_harvested_area.csv'' and ''1999_production.csv'' from the folder ''Guidebook_Dinamica_5\Database\Tables\''. Next, open **Load Table** and load ''IBGE_crop_information_uptated.csv''. |
\\ | \\ | ||
\\ | \\ |