Navigation: Reference > Input >
You need to input data before you can transform it. Data can be input by:
Enter the file location in File or click the browse button. For Excel spreadsheets you also need to add a sheet name, e.g. 'MySpreadsheet.xlsx[Sheet1]'.
Easy Data Transform can input data from files in the following formats:
Easy Data Transform will make an intelligent guess at the:
•column delimiter (e.g. comma) for CSV/TSV/text files
•text encoding (e.g. UTF-8) for CSV/TSV/text files
•presence of a header row in the data
Data will normally be read from the first non-blank line. Set Ignore if you want to ignore a number of rows before you start inputting. Note that empty rows are counted.
Check watch file if you want the file to be automatically reloaded every time that Easy Data Transform detects that it has been changed (which will then update everything 'downstream').
Check trim white space to trim any whitespace (e.g. tabs or spaces) off the start or end of data values.
Check simplify whitespace to replace any tabs or carriage returns within data values with spaces.
Check Ignore empty rows to remove any rows that have only empty values (whitespace is not considered empty).
Use Comment to record any notes that might be useful to a colleague or your future self.
To change the file being used by an input, select the input item and change the file location in the Right pane (e,g, by clicking the '...' browse file button), rather the disconnecting the input and connecting a new one. Otherwise column-related parameters downstream will be reset.