2022.2

Table Of Contents

FieldsalwaysbelongtoanExtractstep,buttheydon'tnecessarilyallcontainextracteddata.Tolearn

howtoaddfieldswithoutextracteddatatoanExtractstep,see"Fields"onpage264.

Adding an Extract step

ToaddanExtractstep,firstselectthestepontheStepspaneafterwhichtoinserttheExtractstep.

Then:

l

IntheDataViewer,selectsomedata,right-clickthatdataandchooseAdd Extraction,ordrag&

dropthedataintheDataModel.Formoredetailedinformationandinstructions,see:"Extracting

data"onpage229.

l

Alternatively,right-clicktheStepspaneandselectAdd a Step > Add Extraction.Makethe

requiredsettingsontheSteppropertiespane.

IfanExtractstepisaddedwithinaRepeatstep,theextracteddataareaddedtoadetailtableby

default;see"Extractingtransactionaldata"onpage235and"Detailtables"onpage298.

Configuring an Extract step

Thenames,order,datatypeanddefaultvalueofthefieldsextractedinanExtractsteparepropertiesof

thatExtractstep.TheseandotherpropertiescanbeeditedviatheSteppropertiespane.Foranexplan-

ationofalltheoptions,see"Extractstepproperties"onpage326.

Note: Datacannotbeextractedmorethanonceinanyrecord,unlesstheExtractstepsaremutu-

allyexclusive.ThisisthecasewhentheyarelocatedindifferentbranchesofaConditionstepor

MultipleConditionsstep.

InsideaDetailtable,multipleExtractstepsmayextractthesamedatabuteachofthemwillcre-

ateanewchildrecordintheDetailtable.

IfyouticktheAppend values to current recordoptionwhenseveralstepsareextractingthesame

field,thestepwillerrorout.

Repeatstep

TheRepeatstepisaloopthatmayrun0ormoretimes,dependingontheconditionspecified.Itisgen-

erallyusedfortheextractionoftransactionaldata;see"Extractingtransactionaldata"onpage235.

Repeatstepsdonotautomaticallymovethepointerinthesourcefile.Therefore,whenaddinga

Repeatstep,aGotostepthatmovesthecursorisinsertedautomaticallyinsidethelooptoavoidan

infiniteloop,exceptwithXMLandJSONdata.

WhenyouselectanodeinanXMLfileandaddaRepeatsteponit,theRepeatstepwillautomatically

loopoverallnodesofthesametypeonthesamelevelintheXMLfile.

Page 251