2022.2

Table Of Contents

staysthesame.

Dropdataonemptyfieldsorontherecorditselftoaddnewfields.

Special conditions

TheExtractstepmayneedtobecombinedwithanothertypeofsteptogetthedesiredresult.

l

DatacanbeextractedconditionallywithaConditionsteporMultipleConditionsstep;see

"Conditionstep"onpage253or"MultipleConditionsstep"onpage256.

l

Normallythesameextractionworkflowisautomaticallyappliedtoallrecordsinthesourcedata.

Itishoweverpossibletoskip records,entirelyorpartially,ortostop data mappingusingan

Actionstep.AddanActionstepinabranchunderaConditionsteporMultipleConditionsstep

(see"Actionstep"onpage257)andsetthetypeofactiontoStopprocessingrecordorStopdata

mapping,accordingtowhatisneeded(see"Actionstepproperties"onpage333).

l

Toextracttransactionaldata,theExtractstepmustbeplacedinsideaRepeatstep.See

"Extractingtransactionaldata"onpage235.

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.

Extracting data into multiple fields

WhenyouselectmultiplefieldsinaCSVortabulardatafileandextractthemsimultaneously,theyare

putintodifferentfieldsintheDataModelautomatically.

InaPDForTextfile,whenmultiplelinesareextractedatthesametime,theyarebydefaultjoinedand

putintoonefieldintheDataModel.Tosplitthemandputthedataintodifferentfields:

1. SelectthefieldintheDataModelthatcontainstheextractedlines.

2. OntheStep propertiespane,underField Definition,clickthedrop-downnexttoSplitand

selectSplit lines.

Page 231