2022.2

Tip: ThedefaultextractionmethodforfieldsinaCSVorXLS(X)fileisdata.extract(colum-
nName, rowOffset).Changingtheexpressiontousethedata.extractByIndex(index,
rowOffset)methodwillallowthedatamappingconfigurationtoextractdatafromfilesthat
havethesamestructure,butdifferentcolumnnames.
Property-based field
Aproperty-basedfieldisfilledwiththevalueofaproperty(see"Propertiesandruntimeparameters"
onpage227).
CustompropertiescanbeaddedviathePreprocessorstep;see"Preprocessorstep"onpage249.
Aproperty-basedfieldcannotbeaddeddirectly.Tofillafieldwiththevalueofaproperty,youhaveto
changeanexistingfield'sModetoProperties.
1. SelectthefieldintheDataModel.
2. OntheSteppropertiespane,underFieldDefinition,changeitsModetoProperties.
3. SelectthepropertyfromthePropertydrop-downlist,orclickthebuttontotheright,toopenafil-
terdialogthatletsyoufindapropertybasedonthefirstfewlettersthatyoutype.
Anotherwaytoaddthevalueofapropertytoafieldisbysettingthefield'sModetoJavaScriptand
enteringthecorrespondingpropertyintheExpressionfield,e.g.data.properties.myProperty;.
Adding empty fields via the Data Model pane
YoucanaddfieldsanddetailtablesdirectlyintheDataModelpane.Right-clickanywhereontheData
Modelandacontextualmenuwillappear.Whichmenuitemsareavailabledependsonwhereyou've
clicked.Ifyouright-clickinsidetherecorditself,youcanaddafield,detailtableorgroup.Afieldwillbe
addedwithnoextraction,whileadetailtablewillbeaddedwithnofieldsinside.
Here'showyoucanfillthefieldwithdata.
l
Drag&dropdataintoit.Thefieldwillbeconvertedintoalocation-basedfieldandisthenaccess-
ibleviatheSteppropertiespane.
l
FillthefieldwithanActionstep(seeExtractingdatawithascript).Fieldsthatarefilledthisway
arenotaccessibleviatheSteppropertiespane.
Adding fields dynamically
OutsideoftheDataMappertheDataModelcannotbechanged.Itisn'tpossibletoaddfieldstoitwhen
usingthedatamappingconfigurationinanautomatedprocess.Itishoweverpossibletoadddatato
existingfieldsviaWorkflow;see"AddingfieldsanddataviaWorkflow"onpage263.
Page 266