2022.2

l
FromtheFilemenu
1. Inthemenu,clickFile > New.
2. ClicktheData mapping Wizardsdrop-downandselectFrom CSV/XLSX/XLS File.
3. ClickNext.
4. ClicktheBrowsebuttonandopenthefileyouwanttoworkwith.
5. ClickNext.
Note: Excelfilessavedin"StrictOpenXML"formatarenotsupportedyet.
Afterselectingthefile,takealookatthepreviewtoensurethatthefileistherightoneandtheencod-
ingcorrectlyreadsthedata.ClickNext.
ForanExcelfileyoucanmakethefollowingsettings:
l
First row contains field names:UsesthefirstrowoftheExcelsheetasheaders,whichauto-
maticallynamesallextractedfields.
l
Sheet:Selectthesheetfromwhichthedatashouldbeextracted.
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selectedcolumnhasnumbers,itwillbesor-
tedasatext.
ForaCSVfilethewizardwilldisplaythedifferentsettingsithasdetected,allowingyoutochangethem:
l
Encoding:Defineswhichencodingisusedtoreadthefile.
l
Separator:Defineswhichcharacterseparateseachfieldinthefile.
l
Comment Delimiter:Defineswhichcharacterstartsacommentline.
l
Text Delimiter:Defineswhichcharactersurroundstextfieldsinthefile.Separatorsandcom-
mentdelimiterswithintextarenotinterpretedasseparatorordelimiter;theyareseenastext.
l
Ignore unparseable lines:Ignoresanylinethatdoesnotcorrespondtothesettingsabove.
l
First row contains field names:UsesthefirstlineoftheCSVasheaders,whichautomatically
namesallextractedfields.
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selectedcolumnhasnumbers,itwillbesor-
tedasatext.
Page 206