Related Links
 QueryLink
 Data Warehouse Overview
 Departments
 Administrative Computing and Telecommunications

 Blink Home > Technology > QueryLink New Balance Feature
QueryLink New Balance Feature  
 
Summary: Personalize a query by adding new columns to combine information from existing columns.
What to do How to do it
1 Open the Balances Wizard.
  1. Open a query.
  2. Click Query Options, scroll down, and click Balances.

  3. The Balance Wizard page will open.
2 Set up the new column.

In this example we'll create a new column showing the result of adding two existing columns.
  1. Highlight a column name (Financial Amount) in your table and click Add.
  2. Click the + button.
  3. Highlight another column name (Encumbrance Amount) and click Add.

3 Name the new column. Use no more than 29 characters.
  1. Enter the name (Financial+Encumbrance) in the title box.
4 Include the new column in the query.
  1. Click Add New Column.
  2. The name of the new column will show in the Balances List.

  3. Delete a column by highlighting the name and clicking Remove New Column.
5 Verify and approve.
  1. Check that the column’s formula is correct and make any adjustments.
  2. Click OK.
6 Finish setting up the query.
  1. Set the other query parameters.
  2. Click Submit. The query will return with the new column.
Note: You'll need to repeat the steps above the next time you want to create the new column.



Questions? Contact Lori Barry, (858) 534-8830.


  Print
Print this page		   Email
Share this page		   Add to MyBlink
Save this link		   Get notified when this page is updated
Notify on change		   Add a sticky note to this page
Add a note		  
Get what you wanted?    yes   no   Comments.
Last reviewed/updated on July 16, 2008 (see more info)
Blink A-Z Index:   0-9  A B C D E F G H  I  J K L M N O P Q R S T U V W X Y Z 


Blink Home  Site Map  Help  Accessibility Tips  Privacy Statement  Content Manager  RSS Feed 


Copyright ©2008 Regents of the University of California. All rights reserved.
Official Web Page of the University of California, San Diego

Blink version 1.7 12-17/2007 Blink Usability Group