Navigation: 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.
2. To add a transform click an existing Center pane item and type the first few letters of the transform name.
3. Check the show advanced checkbox in the Left pane to see all available transforms.
4. Uncheck Run>Auto Run to take full control of when items are processed.
5. Hold down the Shift key and drag on the Center pane to scroll left/right/up/down.
6. Use Note items to remind yourself how a complex .transform works.
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.
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.
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.
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.
13. Click the eye icon in the Right pane to show whitespace in the data.
14. Check compare changes in the Right pane to see changes from a transform (selected transforms only).
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.
16. Enable drilldown to double click on a cell and see how the information was derived.
17. Filter data in the Right pane.
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.
25. Learn keyboard shortcuts. For example, you can quickly change selection in the Center pane using arrow keys with the Cmd key.
26. Change focus between the Center and Right panes using Option+[ and Option+].
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.
31. Use the Subtract transform to perform an 'anti-join'.
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.
35. Use the right click menu to insert control characters into a text option for a transform.
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.
39. Select View>Toggle UI Theme to swap between light and dark user interface themes.
40. Select File>New Window to open a new Main window.
41. Set the Center pane mouse wheel behavior in the Preferences window.