Create IDs from columns Tool

Top 

PTSS Company Logo

 

Create IDs from columns Tool

 

The Create IDs from columns tool allows you to create an ID column in your data from already existing columns in your data which have discrete values, it can be found over here in your Spatial pane( It is a little icon which is a blue circle with a white star):

CREATE~1_img2

 

For example, you may have an existing column in your data which is called Customer Name, the tool can then use this column to generate unique IDs for each different customer name.

 

Before using the tool make sure the appropriate layer that you would like to create the ID column for is highlighted in your layer description box:

CREATE~1_img3

 

Clicking on the tool brings up the following dialogue box:

CREATE~1_img4

 

Firstly, you will choose which column/s in your data you would like to use in the ID calculation, here I chose just one column:

CREATE~1_img5

Then in the ID Field dropdown box you can choose an existing column in your data where you would like the IDs to populate, or you can choose for a new column to be created for the IDs by clicking the New ID field button:

CREATE~1_img6

 

If you have chosen to create a new ID field then the following box will come up, enter the name of the new field then click OK:

CREATE~1_img7

 

Finally, to compute the IDs, click OK:

CREATE~1_img8

 

You will get this message telling you its done, click OK:

CREATE~1_img9

You can then view the resulting IDs in the layer data grid for that layer by right clicking on the layer then selecting View Data:

CREATE~1_img10

CREATE~1_img11

 

You can of course also choose for the calculation to be done on more than one column in your data in which case the tool will take the discrete values in each column into account when creating the IDs.

 

 

 

 

 

 

Support

 

clip0001 

 clip0002

T:  +27871354351

 

support@primethought.biz  - primethought.biz

Kyalami Estate, Midrand, Johannesburg,

1684, South Africa

clip0003clip0004clip0005clip0006clip0007clip0008clip0011