2022.2

DataMapperimmediatelydiscardsnon-requiredfieldsthatarenotreferencedbyany
Extractstep.
Editing the Data Model
TheDataModelisgenerallyconstructedbyextractingdata;see"Extractingdata"onpage229.
Emptyfieldsanddatatablescanbeaddedviathecontextualmenu;see"Addingemptyfieldsviathe
DataModelpane"onpage266.
Editingfields
YoucanmodifythefieldsintheDataModelviathecontextualmenuthatopenswhenyouright-clickon
somethingintheDataModelpane.Foranexplanationoftheoptionsinthismenu,see"DataModelcon-
textualmenu"onpage295.
Aslongasafieldordatatable,addedviatheDataModelpane,remainsempty,itcanbeedited
(renamed,deletedetc.)viathecontextualmenu.
FieldsinaDataModelthatareactuallyusedintheextractionworkflowcannotbeeditedviathecon-
textualmenuoftheDataModelpane.Theyarerelatedtoastepintheextractionworkflowandare
editedviatheSteppropertiespaneinstead(see"Editingfields"onpage267).
OrderingandgroupingfieldsintheDataModel
TomaketheDataModelclearerandmoremanageable,youcanchangetheorderofthefieldsinitand
creategroupsoffields.Allgroupingandorderinginformationissavedinthedatamappingcon-
figuration,sothatwhenyoureopenit,theDataModelwilllookthesame.
Notethatthesechangeshavenoimpactontheorderinwhichdataareextracted,oronthefinal
recordsintheOLConnectdatabase.TheyonlyhelpyouorganizetheDataModelvisually.
Thisalsomeansgroupnamesarenotusedinscripts;fieldsanddetailtablesareaccesseddirectly
throughtherecordobject(seethe"DesignerScriptAPI"onpage1168and"DataMapperScriptsAPI"
onpage360).
Tochangetheorderinwhichdataareextracted,see"Renamingandreorderingfieldsinanextraction
step"onpage267.
Movingfields
Tomoveafield,agroupoffieldsoradetailtable,youcansimplydrag and dropittosomeotherplace
intheDataModel.
Alternatively,youcanright-clickthefield,groupordetailtableandselectoneoftheoptionsinthe
Movemenu,tomoveitupordownwithinthelistorgroup.
Fieldscannotbemovedintoanothertable.However,insideatabletheycanbemovedupordown.
Page 262