Expert tips

<< Click to Display Table of Contents >>

Navigation:  Expert tips >

Expert tips

Here are some tips to help you be more productive with Easy Data Transform.


1. Type a keyword in the transform keywords field to quickly find the right transform.


find transform by keyword


2. To add a transform click an existing Center pane item and type the first few letters of the transform name.


Type to add transform.


3. Check the show advanced checkbox in the Left pane to see all available transforms.


Show advanced transforms.


4. Uncheck Run>Auto Run to take full control of when items are processed.


Auto Run unchecked


5. Hold down the Shift key and drag on the Center pane to scroll left/right/up/down.


Drag pan.


6. Use Note items to remind yourself how a complex .transform works.


Add note items


7. Look in the Warnings and Info tabs in the Right pane to troubleshoot potential issues.




8. Click on icon in the status bar to select and zoom in on all items with that status.


status bar click icon


9. To select multiple items in the Center pane, left click with the mouse and drag a box over the items you want to select.


Drag box to select multiple.


10. Try to avoid disconnecting transforms, as this can reset column related options downstream. Add a transform to an existing connection instead. You can also delete a transform without deleting it's connections.


Insert transforms


11. To improve performance for large datasets, add a Sample transform straight after the input of a large dataset and set Rows to pass through only the first 100 or so rows. Once you have completed all your transforms you can then Disable sampling to pass through all rows.


12. Check View>Timing Profile to see where the processing time is being spent.


Timing profile


13. Click the eye icon in the Right pane to show whitespace in the data.


show whitespace in data


14. Check compare changes in the Right pane to see changes from a transform (selected transforms only).


See transform changes


15. Select a column and click the bars icon in the Right pane to show the frequency of values. Potential issues are shown in red.


show column value frequencies


16. Enable drilldown to double click on a cell and see how the information was derived.


Drilldown into pivot table


17. Filter data in the Right pane.


filter data table


18. Display the currently selected value from in the data table in a separate window by pressing the Space key or selecting Show Value... from the right click menu.


19. If you need several similar branches of transforms you can create one branch and duplicate it.


20. If you have 2 or more monitors connected to your computer try View>Two Screen Mode to show the Right pane on your second monitor.


21. Use batch processing with wildcards (e.g. *.csv) to process a folder full of input files in one operation.


22. Use command line arguments to run .transform files from a batch or script file.


23. Use file name variables to set the name of an output file based on the name of an input file, date created etc.


file name variables


24. Use column variables when you want to use values from columns in transforms such as If and Filter.


Filter using column variable.


25. Learn keyboard shortcuts. For example, you can quickly change selection in the Center pane using arrow keys with the Ctrl key.




26. Change focus between the Center and Right panes using Alt+Left and Alt+Right.


27. Check the gray Left pane buttons when not available checkbox in the General tab of the Preferences window for Left pane buttons to be disabled until the appropriate items in the Center pane are selected.


28. Double click on an item in the Center pane to show it fullscreen. Escape to close the window.


29. Check watch file in the Right pane for an input file if you want to trigger processing (Run>Auto Run checked) or set it to 'Needs update' (Run>Auto Run unchecked) whenever it changes.


30. Check View>Show Row/Col Changes to show changes in the number of rows and columns in the Center pane.


view row and column changes


31. Use the Subtract transform to perform an 'anti-join'.

Join subtract


32. Deploy Easy Data Transform as a portable application so you can run it from a USB key or install it on computers where you have limited access rights.


33. Find items matching one or more search terms in the Center pane using View>Find Items.


34. Magnify under the cursor in the Center pane using View>Magnify Cursor.


Magnify cursor.


35. Use the right click menu to insert control characters into a text option for a transform.


Insert control characters.


36. Use fuzzy matching to match text values that aren't identical.


37. Experiment with changing Optimize processing for from Minimum memory use to Maximum speed in Preferences to see if that improves performance. It may be slower or it may use up all your memory.


38. Change the Center pane color scheme in the Colors tab of the Preferences window.


Color preferences.


39. Select View>Toggle UI Theme to swap between light and dark user interface themes.


Dark mode


40. Select File>New Window to open a new Main window.


41. Set the Center pane mouse wheel behavior in the Preferences window.


Set Center pane mouse wheel behavior.