2022.2

includinginnerjoins,groupingandsorting,youcanusecustomSQLtomakeaselectionfromthe
database,usingwhateverlanguagethedatabasesupports.
Thequerymaycontainvariablesandproperties,sothattheselectionwillbedynamicallyadjus-
tedeachtimethedatamappingconfigurationisactuallyusedinaWorkflowprocess;see"Using
variablesandpropertiesinanSQLquery"onpage320.
l
Encoding:DefineswhatencodingisusedtoreadtheDataSource(US-ASCII,ISO-8859-1,
UTF-8,UTF-16,UTF-16BEorUTF-16LE).
l
Sort on:Allowsto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sortingcolumnhasnumbers,itwillbesorted
asatext.
WithaCustomQuery,thisoptionisnotavailable.
l
Skip empty lines:Ignoreanyrowthathasnocontent,e.g.onlynullsoremptystrings.Notethat
spacesarecharactersandthusconsideredcontent.
Text file Input Data settings
Becausetextfileshavemanydifferentshapesandsizes,therearemanyoptionsfortheinputdatain
thesefiles.
l
Encoding:DefineswhatencodingisusedtoreadtheDataSource(US-ASCII,ISO-8859-1,
UTF-8,UTF-16,UTF-16BEorUTF-16LE).
l
Selection/Text is based on bytes:Checkfortextfilesthatusedouble-bytescharacters
(resolveswidthissuesinsometextfiles).
l
Add/Remove characters:Definesthenumberofcharacterstoaddto,orremovefrom,thehead
ofthedatastream.Thespinbuttonscanalsoincrementordecrementthevalue.Positivevalues
addblankcharacterswhilenegativevaluesremovecharacters.
l
Add/Remove lines:Definesthenumberoflinestoaddto,orremovefrom,theheadofthedata
stream.Thespinbuttonscanalsoincrementordecrementthevalue.Positivevaluesaddblank
lineswhilenegativevaluesremovelines.
l
Maximum line length:Anylinethatislongerthanthegivenmaximumlinelengthwillbesplitat
themaximumlinelength,asoftenasnecessary.Thisoptionisusedtocut(andwrap)longlines
intologicalblocksofdata.
Themaximumvalueforthisoptionis65,535characters.Thedefaultvalueis80characters.
l
Page delimiter type:Definesthedelimiterbetweeneachpageofdata.Multiplesofsuchpages
canbepartofarecord,asdefinedbytheBoundaries.
Page 310