Quick start guide

<< Click to Display Table of Contents >>

Navigation:  Getting started >

Quick start guide

 

This is a quick tour of some of Easy Data Transform's features. It should only take a couple of minutes to complete.

 

Start Easy Data Transform.

 

quick-start-0

 

Drag a data file you want to transform onto Easy Data Transform. Any sort of table or list should be fine. For example a .csv file or (if you have Excel installed) a .xlsx or .xls file.

 

quick-start-1

 

Notice that the available transforms are shown in the Left pane and the selected dataset is shown in the Right pane.

 

In the Right pane, you can click on the has header check box to treat the first row of the dataset a header.

 

quick-start-header

 

All the transforms available for a single dataset are now enabled in the Left pane. Hover over the transforms to see tooltips explaining what they do. Click on the ? next to a transform button for more details.

 

Click on the Case transform button to change the case of your data.

 

quick-start-case

 

A Case transform item will now be added.

 

quick-start-case-b

 

In the Right pane, check the title column and set Change case to to Upper case. All the titles in the output dataset will now be converted to upper case.

 

quick-start-case-2

 

You can create a sequence of transforms to perform complex manipulations.

 

quick-start-sequence

 

Some transforms require more than one input dataset. For example, to stack 2 tables, one on top of the other:

Select File>New to start again. Don't save the changes.

Drag two data files onto the Center pane.

Select both input items (by dragging a box around them or using Ctrl+click).

Click the Stack transform button. You may need to scroll the Left pane to see the button.

 

quick-start-stack

 

The tables are now stacked one on top of the other in a new dataset item. You can choose to match the columns by Header name or Column number.

 

quick-start-stack2

 

Note that the vertical (Y) position of the inputs affects the output. Try swapping the two inputs around to see the affect.

 

Any changes to input files will be automatically read in. Any changes to input datasets or transform options will be automatically propagated 'downstream'.

 

To export your transformed dataset to a file or the clipboard, or to view it in a local editor, select the dataset item and click on the appropriate button in the Left pane.

 

quick-start-export

 

You can also add an output item to automatically output a dataset whenever it changes. You will be asked for a file to output to.

 

quick-start-output-1

 

Your dataset will then be output to this file every time it changes.

 

quick-start-output-2

 

The output item also allows you to specify the delimiter and encoding for the output file.

 

quick-start-output-3

 

You can save your transforms to use again with File>Save.

 

Have a play!

 

Tips:

You can also paste in data from the clipboard (for example, a table from a web page).

The Sort and Filter transforms take account of dates, numbers and text. You can define what date formats are recognized in the Preferences window.

New columns are always added to the right of a table.

Comparisons of text are always sensitive to case. For example, "CASE", "case" and "Case" are treated differently. You can use the Case transform to change case.

Comparisons of text are always sensitive to whitespace (e.g. spaces and tabs). You can use the Trim transform to remove leading and trailing whitespace.

The contents of input data files are not saved in Easy Data Transform.

 

We are very interested in your feedback, so please contact us to ask a question, report a bug or request an enhancement.