Glue tables

Functionality / Algorithm

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: