- Crosstab Operations
A Crosstab operation takes data from a single table or set and uses it to create a new table, in which certain field values from the transaction table are used as field names in the result table. For example, you have City and Sales data from several companies, as shown below:
- Overview of Batch Operations
/documentation/pages/Guides/Desktop/Design/Data/Operation/Overview of Batch Operations.xml
While working with Alpha Anywhere, you can change data at any time by simply navigating to a record and typing in new values. This method is fine if you are just working with a few records, but editing can become enormously time-consuming if you are working with hundreds or thousands of records. To handle larger data manipulation tasks, you can use an Alpha Anywhere Operation. "Operation" is a general term for a process which changes data in existing tables, or even creates new tables as Part of the operation.
- Viewing the Xbasic of Operations
/documentation/pages/Guides/Desktop/Design/Data/Operation/Viewing the Xbasic of Operations.xml
Alpha Anywhere allows you to create and save operations that you users may need to perform on a repetitive basis. The operations that you may create are:
- Query Operations
This page provides an overview of query operations and looks at how to perform them.
- Summarize Operations
A guide to performing summarize operations, grouping records, and using the summarize genie.
- Update Operations
A guide to performing update operations and how to use the update genie.
- Post Operations
A guide to performing post operations and to using the post genie.
- Copy Operations
A guide to performing copy operations and using the copy genie.
- Import Operations
A guide to using import operations and how to use the import genie in desktop applications.
- Append Operations
An append operation takes the records from the transaction table and adds them to the data in the master table. The append operation: