You can learn more about Tablecruncher’s Javascript macros in our documentation. ![]() This tutorial should give you some ideas on how to implement your data cleansing tasks utilizing the power of the builtin Javascript language. Flag duplicate rowsįor( r = ROWMIN+1 r Delete Flagged Row(s) …. Insert the following code into the source area of the macro editor. With our sorted column selected, we choose Macro > Execute Macro …, click the little “+” sign and add a new macro with the name “Find Duplicates”. We select our sorted column by clicking on its column header. He’s come on leaps and bounds thanks to the supportive but playful methodology employed by Lead Table Cruncher and education expert, Alice. To achieve this, just right-click the header of our column “E-Mail” or use Data > Sort … and choose the correct column from the dropdown.Īfter clicking Sort the table is sorted by the value of the chosen column. With the pressure removed from the learning of times tables which are still all too often associated with intense assaults of quick-fire questions, my child was able to relax and enjoy the process. ![]() This step ensures all rows with duplicates are grouped together. Now we’re going to sort the column which possibly contains duplicate entries. Step 2: Sort the column with the values to check for duplicates This is our initial file that serves as an example for this tutorial. The macro API is subject to change and more powerful features will be added in the future, making tasks like this one easier. Always make backups of your files before manipulating them with Tablecruncher. Please be aware, that Tablecrucher is still in beta. The process for finding duplicates has been extremly simplified with the introduction of flagged rows in version 0.9.8. This tutorial shows how to find and delete entries with a duplicate column. Since version 0.9.7 Tablecruncher provides Javascript as a builtin macro language. ![]() A typical task when working with CSV files is to find and process duplicates, very often to delete them.
0 Comments
Leave a Reply. |