FieldMapping

FieldMapping.cs

using System;
using System.Collections.Generic;
using System.Text;
using ESRI.ArcGIS.Geodatabase;
using ESRI.ArcGIS.Geoprocessing;
using ESRI.ArcGIS.Geoprocessor;
using ESRI.ArcGIS.esriSystem;
using ESRI.ArcGIS.ConversionTools;

namespace GPFieldMapping
{
    class FieldMapping
    {
        static void Main(string[] args)
        {
            // Initialize license
            ESRI.ArcGIS.RuntimeManager.Bind(ESRI.ArcGIS.ProductCode.Desktop);
            IAoInitialize aoi = new AoInitializeClass();
            aoi.Initialize(esriLicenseProductCode.esriLicenseProductCodeArcInfo);

            // Initialize the Geoprocessor
            Geoprocessor GP = new Geoprocessor();
            
            // Create the GPUtilites object
            IGPUtilities gputilities = new GPUtilitiesClass();

            // Create a DETable data element object 
            IDETable inputTableA = (IDETable)gputilities.MakeDataElement(@"C:\gp\citiblocks.gdb\census", null, null); 

            // Create an array of input tables
            IArray inputtables = new ArrayClass();
            inputtables.Add(inputTableA);

            // Initialize the GPFieldMapping
            IGPFieldMapping fieldmapping = new GPFieldMappingClass();
            fieldmapping.Initialize(inputtables, null);
            
            // Create a new output field
            IFieldEdit trackidfield = new FieldClass();
            trackidfield.Name_2 = "TRACTID";
            trackidfield.Type_2 = esriFieldType.esriFieldTypeString;
            trackidfield.Length_2 = 50;

            // Create a new FieldMap
            IGPFieldMap trackid = new GPFieldMapClass();
            trackid.OutputField = trackidfield;

            // Find field map "STFID" containing the input field "STFID". Add input field to the new field map.
            int fieldmap_index = fieldmapping.FindFieldMap("STFID");
            IGPFieldMap stfid_fieldmap = fieldmapping.GetFieldMap(fieldmap_index);
            int field_index = stfid_fieldmap.FindInputField(inputTableA, "STFID");
            IField inputField = stfid_fieldmap.GetField(field_index);
            trackid.AddInputField(inputTableA, inputField, 5, 10);

            // Add the new field map to the field mapping
            fieldmapping.AddFieldMap(trackid);

            // Execute Table to Table tool using the FieldMapping
            TableToTable tblTotbl = new TableToTable();
            tblTotbl.in_rows = inputTableA;
            tblTotbl.out_path = @"C:\gp\citiblocks.gdb"; 
            tblTotbl.out_name = "CensusVista";
            tblTotbl.field_mapping = fieldmapping;

            GP.Execute(tblTotbl, null);
        }
    }
}

FieldMapping.vb

Imports Microsoft.VisualBasic
Imports System
Imports System.Collections.Generic
Imports System.Text
Imports ESRI.ArcGIS.Geodatabase
Imports ESRI.ArcGIS.Geoprocessing
Imports ESRI.ArcGIS.Geoprocessor
Imports ESRI.ArcGIS.esriSystem
Imports ESRI.ArcGIS.ConversionTools

Namespace GPFieldMapping
	Friend Class FieldMapping
		Shared Sub Main(ByVal args As String())
            ' Initialize license
            ESRI.ArcGIS.RuntimeManager.Bind(ESRI.ArcGIS.ProductCode.Desktop)

            Dim aoi As IAoInitialize = New AoInitializeClass()
            aoi.Initialize(esriLicenseProductCode.esriLicenseProductCodeArcInfo)

            ' Initialize the Geoprocessor
            Dim GP As ESRI.ArcGIS.Geoprocessor.Geoprocessor = New ESRI.ArcGIS.Geoprocessor.Geoprocessor()

			' Create the GPUtilites object
			Dim gputilities As IGPUtilities = New GPUtilitiesClass()

			' Create a DETable data element object 
            Dim inputTableA As IDETable = CType(gputilities.MakeDataElement("C:\gp\citiblocks.gdb\census", Nothing, Nothing), IDETable) 

			' Create an array of input tables
			Dim inputtables As IArray = New ArrayClass()
			inputtables.Add(inputTableA)

            ' Initialize the GPFieldMapping
			Dim fieldmapping As IGPFieldMapping = New GPFieldMappingClass()
			fieldmapping.Initialize(inputtables, Nothing)

			' Create a new output field
			Dim trackidfield As IFieldEdit = New FieldClass()
			trackidfield.Name_2 = "TRACTID"
			trackidfield.Type_2 = esriFieldType.esriFieldTypeString
			trackidfield.Length_2 = 50

			' Create a new FieldMap
			Dim trackid As IGPFieldMap = New GPFieldMapClass()
			trackid.OutputField = trackidfield

			' Find field map "STFID" containing the input field "STFID". Add input field to the new field map.
			Dim fieldmap_index As Integer = fieldmapping.FindFieldMap("STFID")
			Dim stfid_fieldmap As IGPFieldMap = fieldmapping.GetFieldMap(fieldmap_index)
			Dim field_index As Integer = stfid_fieldmap.FindInputField(inputTableA, "STFID")
			Dim inputField As IField = stfid_fieldmap.GetField(field_index)
			trackid.AddInputField(inputTableA, inputField, 5, 10)

			' Add the new field map to the field mapping
			fieldmapping.AddFieldMap(trackid)

			' Execute Table to Table tool using the FieldMapping
			Dim tblTotbl As TableToTable = New TableToTable()
			tblTotbl.in_rows = inputTableA
            tblTotbl.out_path = "C:\gp\citiblocks.gdb" 
            tblTotbl.out_name = "CensusVistaVB"
			tblTotbl.field_mapping = fieldmapping

			GP.Execute(tblTotbl, Nothing)
		End Sub
	End Class
End Namespace