The Glue tables operation allows you to glue or merge two or more tables together. As input tables, you may use:
The Glue tables operation should be regarded as a tool to combine different tables. You can for instance combine or integrate attribute tables of different years. Tables with domain None can also be glued vertically one below the other.
The operation will automatically determine:
Then, fields in the input tables will be copied to the output table.
In the dialog box, you can select 2, 3, or 4 input tables. On the command line, you can specify as many input tables as you like.
Process:
First, the domain for the output table will be determined; the domain for the output table depends on the domains that are used by the input tables:
Then, the columns to be copied to the output table will be examined.
For input tables with a class or ID domain and for input tables with domain None (no vertical gluing):
For input tables with domain None and when you selected the option vertical gluing:
When a new Class or ID domain is created for the output table, this domain will obtain the same name as the output table. On the command line, you can also specify a name for the output domain yourself.
Examples:
1. Combining tables with domain None and using option Vertical:
First input table |
Second input table |
Output table |
Direction |
Length |
Direction |
Length |
Direction |
Length |
|||
1 |
0 |
2223 |
1 |
5 |
6993 |
1 |
0 |
2223 |
2 |
1 |
4737 |
2 |
6 |
1123 |
2 |
1 |
4737 |
3 |
2 |
2048 |
3 |
7 |
4273 |
3 |
2 |
2048 |
4 |
3 |
6000 |
4 |
8 |
1827 |
4 |
3 |
6000 |
5 |
4 |
0 |
5 |
9 |
1265 |
5 |
4 |
0 |
|
|
|
|
|
|
6 |
5 |
6993 |
|
|
|
|
|
|
7 |
6 |
1123 |
|
|
|
|
|
|
8 |
7 |
4273 |
|
|
|
|
|
|
9 |
8 |
1827 |
|
|
|
|
|
|
10 |
9 |
1265 |
2. Combining tables with domain Class:
First input table |
Second input table |
Output table |
Landvalue80 |
Landvalue90 |
Landvalue80 |
Landvalue90 |
|||
Agriculture |
75 |
Agriculture |
100 |
Agriculture |
75 |
100 |
Agriculture (irrig) |
125 |
Agriculture (irrig) |
150 |
Agriculture (irrig) |
125 |
150 |
Bare rock |
10 |
Airport |
600 |
Airport |
? |
600 |
Bare soils |
10 |
Bare rock |
50 |
Bare rock |
10 |
50 |
Forest |
25 |
Bare soils |
50 |
Bare soils |
10 |
50 |
Grassland |
25 |
Forest |
75 |
Forest |
25 |
75 |
Lake |
? |
Grassland |
75 |
Grassland |
25 |
75 |
Riverbed |
? |
Lake |
? |
Lake |
? |
? |
Shrubs |
35 |
Riverbed |
? |
Riverbed |
? |
? |
Urban center |
750 |
Shrubs |
50 |
Shrubs |
35 |
50 |
Urban periphery |
500 |
Urban center |
1000 |
Urban center |
750 |
1000 |
Urban periphery |
750 |
Urban periphery |
500 |
750 |
Domain of output table:
When a new domain is created for the output table, the domain will obtain the same name as the output table. On the command line, you can also specify a name for the output domain yourself.
See also: