2022.2

Table Of Contents
1. OntheDataModelpane,clickoneofthefieldsinthedetailtable.
2. OntheStepPropertiespane,underExtraction Definition,intheData Tablefield,youcanfind
thenameofthedetailtable:record.detailbydefault.Changethedetailpartinthatnameinto
somethingelse.
Note: Adetailtable’snameshouldalwaysbeginwith‘record..
3. ClicksomewhereelseontheStepPropertiespanetoupdatetheDataModel.Youwillseethe
newnameappear.
Creatingmultipledetailtables
Multipledetailtablesareusefulwhenmorethanonetypeoftransactionaldataispresentinthesource
data,forexamplepurchases(itemswithasetprice,quantity,itemnumber)andservices(withaprice,
frequency,contractenddate,etc).
Tocreatemorethanonedetailtable,simplyextracttransactionaldataindifferentRepeatsteps(see
"Extractingtransactionaldata"onpage235).
Thebestwaytodothisistoaddanemptydetailtable(right-clicktheDataModel,selectAdd a table
Page 270