data_join_wizard
Differences
This shows you the differences between two versions of the page.
| Next revision | Previous revision | ||
|
data_join_wizard [2015/09/28 06:56] 127.0.0.1 external edit |
data_join_wizard [2015/09/28 08:22] (current) admin |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| - | ====== Data_Join_Wizard ====== | + | ====== Data Join Wizard ====== |
| The Data Join Wizard dialog is used to match records from a layer on the your map to records in a delimited file when the values of one (or two) columns are equal in both places. | The Data Join Wizard dialog is used to match records from a layer on the your map to records in a delimited file when the values of one (or two) columns are equal in both places. | ||
| Line 12: | Line 12: | ||
| ===== Video Overview ===== | ===== Video Overview ===== | ||
| - | {{#ev:youtubehd|wnKH83kxYN4|720||Using the Data Join wizard.}} | + | {{youtube>wnKH83kxYN4?720|Using the Data Join wizard.}} |
| - | [[Category:Processing Data]] [[Category:Articles with Video]] | ||
| ===== Step 1 - Choose the Layer ===== | ===== Step 1 - Choose the Layer ===== | ||
| Line 25: | Line 24: | ||
| ===== Step 3 - Select Columns to Join On ===== | ===== Step 3 - Select Columns to Join On ===== | ||
| - | {{wiki:DataJoin_tbl1.png ?250|Using 'Product' column as the common data}} | + | <div imagewithremaker right width250> |
| + | {{ wiki:DataJoin_tbl1.png ?250|Using 'Product' column as the common data}} | ||
| + | Using 'Product' column as the common data | ||
| + | </div> | ||
| In Step 3 of the Data Join Wizard, choose the columns from your layer and your delimited file that must have matching values. The best way to join data is by using a unique common data set between the layer and delimited file. You may need to select multiple column conditions, by clicking the "**+**" under the first condition, to get the result that you need. There is also a View Layer Data button and View Delimited File Data on this step to allow users to view the column data of each to determine the best column to match with. | In Step 3 of the Data Join Wizard, choose the columns from your layer and your delimited file that must have matching values. The best way to join data is by using a unique common data set between the layer and delimited file. You may need to select multiple column conditions, by clicking the "**+**" under the first condition, to get the result that you need. There is also a View Layer Data button and View Delimited File Data on this step to allow users to view the column data of each to determine the best column to match with. | ||
| ===== Step 4 - Configure the Output ===== | ===== Step 4 - Configure the Output ===== | ||
| + | <div imagewithremaker right width250> | ||
| {{wiki:DataJoin_Result.png ?250|Result of Data Join with columns from both files added}} | {{wiki:DataJoin_Result.png ?250|Result of Data Join with columns from both files added}} | ||
| + | Result of Data Join with columns from both files added | ||
| + | </div> | ||
| Step 4 of the Data Join Wizard allows users to select which data to include in the output layer. This step has an Available Columns list box on the left which allows users to see all columns from the input layer and delimited file. Users can use the All checkbox to select all, or the filter select box to only show columns from either the input layer or delimited file. Users can then select the necessary columns and press the right arrow (-->) button to add the columns into the Columns to Include list box. Once the user has the necessary columns in the Columns to Include list box, they can press Next > to proceed to Step 5. | Step 4 of the Data Join Wizard allows users to select which data to include in the output layer. This step has an Available Columns list box on the left which allows users to see all columns from the input layer and delimited file. Users can use the All checkbox to select all, or the filter select box to only show columns from either the input layer or delimited file. Users can then select the necessary columns and press the right arrow (-->) button to add the columns into the Columns to Include list box. Once the user has the necessary columns in the Columns to Include list box, they can press Next > to proceed to Step 5. | ||
data_join_wizard.1443423407.txt.gz · Last modified: 2015/09/28 08:13 (external edit)
