# Edit Data Set Mapping

**URL:** <https://speciforum.org/t/edit-data-set-mapping/265>\
**Category:** Specify 6 Documentation\
**Tags:** Specify-6\
**Created:** [March 17, 2022, 7:36pm UTC](https://speciforum.org/t/edit-data-set-mapping/265 "2022-03-17T19:36:16Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Grant](https://yyz1.discourse-cdn.com/flex029/user_avatar/speciforum.org/grant/32/4255_2.png) [@Grant](https://speciforum.org/u/Grant)\
**Post date:** [March 17, 2022, 7:36pm UTC](https://speciforum.org/t/edit-data-set-mapping/265/1 "2022-03-17T19:36:16Z")

</div>

## Edit Data Set Mapping

To edit the Data Set Mapping, find the data set on the side bar and right-button click on it. If the data set is currently open, you will need to close it before editing the mapping.

A context menu will appear:

![Mapping Button](https://canada1.discourse-cdn.com/flex029/uploads/specifysoftware/original/2X/e/e49fba991d553592c3eac15071c8132c5e087f2e.png)

Edit Data Set Mapping Context Menu

&nbsp;

Click on 'Edit Data Set Mapping' to display the Data Set Mapping Editor dialog:

 ![Data Set Mapping Editor](https://canada1.discourse-cdn.com/flex029/uploads/specifysoftware/original/2X/6/6e9344777162aa8b5b487727a887326bd41e44e7.png)

Data Set Mapping Editor

The buttons in the dialog enable columns to be mapped, unmapped, added, deleted and reordered:

| ![map](https://canada1.discourse-cdn.com/flex029/uploads/specifysoftware/original/2X/4/42e2683a0676bc66a460c81071dffed0ba116436.png) | Map | Adds the field to the column list. |
| ![unmap](https://canada1.discourse-cdn.com/flex029/uploads/specifysoftware/original/2X/2/28ff08d8270e2c0ee20b1f549cd521bcfeb884a4.png) | Unmap | Removes the field from the list of columns. |
| ![reorderup](https://canada1.discourse-cdn.com/flex029/uploads/specifysoftware/original/2X/f/f6d3b4c83dd216935dfae09af9cdd89107e15981.png) | Reorder up | Moves the selected field up. |
| ![reorderdown](https://canada1.discourse-cdn.com/flex029/uploads/specifysoftware/original/2X/8/8b6d8a6caf1906fbd1726f7ce90813ff0de082d9.png) | Reorder down | Moves the selected field down. |

&nbsp;

To unmap a column:

1. Click on the column to select it.
2. Click the ![unmap](https://canada1.discourse-cdn.com/flex029/uploads/specifysoftware/original/2X/2/28ff08d8270e2c0ee20b1f549cd521bcfeb884a4.png)(unmap) button.

&nbsp;

To remap a column:

1. Click on the Data Set Column to select it.
2. Click on the Data Type to show the Specify fields in the 'Fields' window.
3. Click on the Specify field.
4. Click the ![map](https://canada1.discourse-cdn.com/flex029/uploads/specifysoftware/original/2X/4/42e2683a0676bc66a460c81071dffed0ba116436.png)(map) button.

&nbsp;

To add a column:

1. Click on the Data Type to show the Specify fields in the 'Fields' window.
2. Click on the Specify field.
3. Click the ![map](https://canada1.discourse-cdn.com/flex029/uploads/specifysoftware/original/2X/4/42e2683a0676bc66a460c81071dffed0ba116436.png)(map) button.

A ![link](https://canada1.discourse-cdn.com/flex029/uploads/specifysoftware/original/2X/4/4d4d43bee241854de37b1d2e2e0e4dad4cec8068.png)&nbsp;(link) icon will appear identifying that the column and field are the same heading.

&nbsp;

To reorder the columns:

1. Click on Data Set Column to select it.
2. Click the ![reorderup](https://canada1.discourse-cdn.com/flex029/uploads/specifysoftware/original/2X/f/f6d3b4c83dd216935dfae09af9cdd89107e15981.png)(reorder up) or ![reorderdown](https://canada1.discourse-cdn.com/flex029/uploads/specifysoftware/original/2X/8/8b6d8a6caf1906fbd1726f7ce90813ff0de082d9.png)(reorder down) until the column is in the correct position.

&nbsp;

**Note:** A field may only map once. Specify fields that are mapped display a green check mark next to their name in the Specify field list confirming that they are in use.

&nbsp;
