2022.2

l
Next Record:Gotothenextrecordinthedatasample.Thisbuttonisdisabledifthelastrecordis
shown.
l
Last Record:Gotothelastrecordinthedatasample.Thisbuttonisdisabledifthelastrecordis
alreadyshown.IfarecordlimitissetintheSettingspane("Settingspane"onpage307)thelast
recordwillbewithinthatlimit.
Detail tables
AdetailtableisafieldintheDataModelthatcontainsarecordsetinsteadofasinglevalue.Detail
tablescontaintransactionaldata.TheyarecreatedwhenanExtractstepisaddedwithinaRepeat
step;see"Extractingtransactionaldata"onpage235.
Inthemostbasicoftransactionalcommunications,asingledetailtableissufficient.However,itispos-
sibletocreatemultipledetailtables,aswellasnestedtables.Detailtablesandnestedtablesaredis-
playedasseparatelevelsintheDataModel(see"TheDataModel"onpage260).
DetailtablescanbeincludedinatemplateviaaDynamic Table;see"DynamicTable"onpage742.
Renaming a detail table
Renamingdetailtablesisespeciallyusefulwhentherearemoredetailtablesinonerecord,orwhena
detailtablecontainsanotherdetailtable.Forthisdetailtable,‘products’wouldbeabettername.
1. OntheDataModelpane,clickoneofthefieldsinthedetailtable.
2. OntheStepPropertiespane,underExtraction Definition,intheData Tablefield,youcanfind
thenameofthedetailtable:record.detailbydefault.Changethedetailpartinthatnameinto
somethingelse.
Note: Adetailtable’snameshouldalwaysbeginwith‘record.’.
3. ClicksomewhereelseontheStepPropertiespanetoupdatetheDataModel.Youwillseethe
newnameappear.
Creating multiple detail tables
Multipledetailtablesareusefulwhenmorethanonetypeoftransactionaldataispresentinthesource
data,forexamplepurchases(itemswithasetprice,quantity,itemnumber)andservices(withaprice,
frequency,contractenddate,etc).
Page 298