2022.2

ManualsBrandsObjectif Lune ManualsApplicationsPlanetPress Connect

711

712

713

714

715

716

717

718

719

720

Table Of Contents

l

Ignore unparsable lines:Whenchecked,anylinethatdoesnotcorrespondtotheaboveset-

tingswillbeignored.

l

First row contains field names:CheckthisoptiontousethefirstlineoftheCSVasheaders.

Thisoptionautomaticallynamesallextractedfields.

l

Sort on:Selectafieldonwhichtosortthedata,inascending(A-Z)ordescending(Z-A)

order.Notethatsortingisalwaystextual.Eveniftheselectedcolumnhasnumbers,itwill

besortedasatext.

Microsoft Access MDB file options

l

File:Includethefullpathtothefile.

l

Password:Ifthefileisn'tpasswordprotected,youcanclickNextwithoutfillingoutthisfield.

l

Table name:Usethedrop-downtoselecttheappropriatetableorstoredquerytoretrievethe

appropriatedataset.

l

Encoding:Usethedrop-downtoselecttheencodingwithwhichtoreadthedatainthetable.

l

Sort on:Selectafieldonwhichtosortthedata,inascending(A-Z)ordescending(Z-A)

order.Notethatsortingisalwaystextual.Eveniftheselectedcolumnhasnumbers,itwill

besortedasatext.

JSON file options

AfterselectingaJSONfile,specifyifandhowtheJSONfilemustbesplitintomultiplerecords.

Thisisdonebyselectinganobjectorarrayasparent element.Itsdirectchildelements-objectsand

arrays,notkey-valuepairs-canbeseenasindividualsourcerecords.Iftherootisselected,therewill

beonlyonesourcerecord.

Whethersourcerecordsareoutputasindividualrecordsdependsonthetrigger.Either:

l

SelectOn elementtocreateanewrecordintheoutputforeachobjectorarrayintheparentele-

ment.

l

SelectOn changetocreateanewrecordeachtimethevalueinacertainkey-valuepair

changes.Onlykey-valuepairsthatexistattherootofachildelementcanbeevaluated.

Alldatafoundinchildelementsoftheselectedparentelementareextractedtofieldsattherootofthe

DataModel.Ifavalueconsistsofanobjectorarray,theentireobjectorarrayisextractedtoonedata

field.

Fieldnamesarederivedfromkeys,objectsandarraysinthefirstrecord,butthosearen'tnecessarily

thesameinasubsequentrecord.Iffollowingrecordshaveadifferentstructure,forexampleifarecord

hasmorechildelementscomparedtothefirstrecord,somedatamaynotgetextracted.

Page 714