Question

Merging and altering attribute tables

  • 15 February 2019
  • 2 replies
  • 1 view

Hello

I would like some suggestions for a task I have.

I have several different shapefiles each of them with a different table structure.

What to want to achieve is to merge them to a new shapefile with a new table structure that will 'pick' certain features from the columns of the shapefiles and populate the new table:

Example

 

 

 


2 replies

Badge +2

Hi @kostass,

 

I'm a big fan of using the AttributeManager for tasks like this but you could also use something the SchemaMapper. If you use the AttributeManager approach, you simply need:

  1. Add both Shapefiles to the canvas
  2. Connect both reader feature types to the AttributeManager
  3. Rename the Output Attributes to "Name" and "Date" and remove the unwanted attributes by setting the Action to "Remove"

     

     

     

  4. Lastly, connect the AttributeManager to a Shapefile writer.

Your workspace will look something like this (except you will use a shapefile writer instead of the Inspector)

Input

Output

Helpful Resources:

Userlevel 2
Badge +12

Not as good as the suggestion by @ChrisAtSafe, but if you want to keep it as simple as possible:

Open the reader and writer attributes by clicking on the little triangles and simply connect the attributes will do too.

Like this:

Reply