2022.2

Table Of Contents

Tip: YoumayedittheJsonPathintheJsonPath Collectionfieldtoinclude or exclude

elementsfromtheloop.ForanoverviewoftheJsonPathsyntax,seehttps://-

github.com/json-path/jsonpath.

3. (Optional.)AddanemptydetailtableviatheDataModelpane:right-clicktheDataModeland

selectAddatable.Givethedetailtableaname.

4. SelecttheRepeatstepontheStepspane.

5. Extractthedata:insidethefirstoftherepeatingelements,selectthedatathatyouwantto

extract.Thenright-clicktheselectednodesandselectAdd Extraction,ordrag&dropinthe

DataModel.

Whenyoudrag&dropdataonthenameofadetailtableintheDataModelpane,thedataare

addedtothatdetailtable.

DroppingthedatasomewhereelseontheDataModelpanecreatesanewdetailtable,witha

defaultnamethatyoucanchangelateron(see"Renamingadetailtable"onpage298).

ThenewExtract stepwillbelocatedintheRepeatstep.

About JsonPath

TheDataMappermovesthroughJSONfilesusingJsonPath,apath-likesyntaxtoidentifyandnavigate

elementsinaJSONdocument.ForanoverviewoftheJsonPathsyntax,seehttps://github.com/json-

path/jsonpath.

IntheDataMappertheJsonPathcanbeabsolute(startwith$whichistheroot)orrelativetothecurrent

position(startwith.whichisthecurrentelement).

AJsonPathcanberelativeorabsolute.Note,however,thatwitharelativeJsonPathgoinguptoapar-

entelementisnotpossible.

Tip: ThefullJsonPathtoanelementisdisplayedatthebottomleftofthewindowwhenyou

selectit.Tocopythepath,right-clickitandselectCopy.

Note: IfakeyinaJSONfilehasanamethatlookslikeafunction(e.g."TLIST(A1)"),thenthe

ExtractstephastouseaJsonPathwithbracketnotationinsteadofthedefaultdotnotation.For

informationaboutthebracketnotationseehttps://goessner.net/articles/JsonPath/.

From a Text or a PDF file

InaPDForTextfile,transactionaldataappearsonmultiplelinesandcanbespreadovermultiple

pages.

Page 241