2022.2

Thenestedtablescanbecalledrecord.services.chargesandrecord.services.details.
Nowone"charges"tableandone"details"tablearecreatedforeachrowinthe"services"table.
Data types
BydefaultthedatatypeofextracteddataisaString,buteachfieldintheDataModelcanbesettocon-
tainanotherdatatype.
Todothis:
1. IntheData Model,selectafield.
2. OntheStep propertiespane,underField DefinitionchooseadatatypefromtheTypedrop-
down.
Changingthetypedoesnotonlysetthedatatypeinsidetherecord.Inthecaseofdates,numbersand
currencies,italsomeansthattheDataMapperwillexpectthedatainthedatasourcetobeformattedin
acertainway.Iftheactualdatadoesn'tmatchtheformatthattheDataMapperexpects,itcannotinter-
pretthedate,numberorcurrencyassuch.Ifforexampleadateinthedatasourceisformattedas
"yyyy-mm-dd"butthedefaultformataddsthetime,thedatecannotbereadandtheDataMapperwill
stopwithanerror.
Thedefaultformatfordates,numbersandcurrenciescanbesetintheuserpreferences("DataMapper
preferences"onpage786),inthedatasourcesettings()andperdatafield(intheExtractstepprop-
erties,see"DataFormat"onpage331).
Page 275