Monthly Archives: December 2014

Tips & Tricks: Using the Log to Rerun a Join

Did you ever run a complicated join and realized you forgot to add one primary field or that the length of your primary fields did not match? Rerunning a join through point and click can be a tedious task; however the log can be your best friend whenever you need to tweak something.

  1. Select the log so it opens in the display area of the left side.Join_1
  2. Find the last JOIN command that you would like to make changes to. If you have a hard time finding where your last join occurred, you can do a search in the log.
  3. To search in the log, right click and select ‘Find.’Join_2
  4. Enter the main word that you would like to find in the log. In this case, I wanted the log to find anything with the word Join. You can select the direction that you would like to search in as well. Knowing that my Join was done recently, I selected up. This means that it will start looking from the bottom to the top for the word I want it to find.Join_4

After clicking through some of the results, I have now found the Join that I would like to makeĀ  changes to.

Join_4_2

  1. Click on your Primary Table (in this example the Primary Table is Payroll) and select Run in the Command Line. Do the same thing for the Secondary Table.Join_7
  2. Click on your last JOIN command and double-click the command underlined in blue in the display area.Join_6
  3. Your original JOIN dialog box will appear with all of your previous setting. Make any changes in the dialog box and run.Join_7
  4. After the new Join runs, open the log again and copy and paste it into the script. We recommend doing this to help save time in the future as it will make it easier to refer back to if you ever need to make any other changes.

Join_8

Bonus Tip: This little trick applies to anything in the log that you might want to add or do differently including commands such as Summarize, Classify, Statistics, and Total.