One Tool Example
Cross Tab has a One Tool Example. Visit Sample Workflows to learn how to access this and many other examples directly in Alteryx Designer.
Use Cross Tab to pivot the orientation of data in a table by moving vertical data fields onto a horizontal axis and summarizing data where specified. The Cross Tab tool is the reverse application of the Transpose tool, which pivots the orientation of the data from horizontal to vertical. There is no limit to the number of rows or columns that can be passed through the Cross Tab tool.
In versions before Designer 10.5, identical strings with differing capitalization were used to create separate columns with modified names. In 10.5 and later, if two or more cells contain the same string with different capitalization, an error will be produced at runtime. To resolve this, ensure that data in each cell is unique or that the capitalization is consistent for matching data.
Configure the Tool
- A list of all available data values displays in the Group data by these values section. Select the values that should be used to group the data. Data with identical values are grouped together into a single row.
- Select a value from the Change Column Headers dropdown. A new column is created for each unique value.
- Select a value from the Values for New Columns dropdown. These values are used to populate the new columns.
- Select
a Method for Aggregating Values for combining multiple values in a field. Available options depend on the data type of the value selected in the Values for New Columns field.
- Options for String data include...
- Concatenate: Separates the values using the separator specified in the Separator field.
- First: Displays the first found value.
- Last: Displays the last found value.
- Options for Number data include...
- Sum: Sums the values.
- Average: Calculates an average of the values.
- Count [without Nulls]: Counts the number of values excluding null values.
- Count [with Nulls]: Counts the number of values including null values.
- Percent Row: Calculates a percent based on the values.
- Percent Column: Calculates a percent based on the values.
- Total Column: Totals all of the values.
- Total Row: Adds a new row containing a total of the values.
- When you choose one or more of the methods above, an abbreviation for that method will be prepended to the column header, unless Sum, First, or Last is the only method selected.
AVG_FieldValue, SUM_FieldValue, COUNT_FieldValue.
- Options for String data include...
- The character specified in the Separator field is automatically added between concatenated strings. This option is only available when concatenating strings.
- The Field Size field is the maximum field length [in characters] for concatenating strings. If the string is larger than the size specified, a warning appears in the Results window and the data is truncated. Visit the Data Types article for information on string data types.
Upgrade to remove ads
Only SGD 41.99/year
- Science
- Computer Science
-
Flashcards
-
Learn
-
Test
-
Match
-
Flashcards
-
Learn
-
Test
-
Match
Terms in this set [40]
Which of the following groups is not on the Print Preview tab?
Properties
To freeze a column, click within the column you want to freeze, click the _____ button, and then click _____ at the drop-down list.
More; Freeze Fields
A database is comprised of a series of _____ used to enter, manage, view, and print data.
Objects
The Add & Delete group is located on the _____ tab and contains five buttons for assigning data types plus a More Fields button.
Table Tools Fields
This feature displays messages, the current view, and view buttons.
Status Bar
What happens if you enter four characters into a text field that has a field size of two?
Access will not accept the additional text
Each field in a table must have
a unique name
To display a different subdatasheet, remove the subdatasheet first, before selecting the next subdatasheet. Do this by clicking the _____, pointing to Subdatasheet, and then clicking Remove.
More button
In a one-to-many relationship, which table would contain the foreign key for the relationship?
related table
Typically, a primary key field in one table becomes _____ in a related table.
the foreign key field
If a table has more than one relationship defined, clicking the expand indicator will display the
Insert Subdatasheet dialog box.
File management systems are sometimes referred to as
flat file databases
The Relationships window displays _____ you have defined between tables.
all relationships
Multiple criteria all entered in the same row in the query design grid is considered a[n] _____ statement.
And
What is the minimum number of fields needed to create a crosstab query?
three
If you suspect that a client has been entered into your Clients table under two different client numbers, you would use a _____ query to find the problem.
find duplicates
In the third [and last] Simple Query Wizard dialog box, you specify a name for your query, and then you are given the option to either _____ or _____ the query.
open; modify
Crosstab queries must be built from fields contained in
one table
How do you start the Input Mask Wizard?
Click the Build button at the right of the Input Mask property box.
By default, the Long Text data type uses _____ formatting.
plain text
In which Lookup Wizard dialog box are you asked for the values you would like to see in your lookup field?
second
To print specific records in a table, begin by
selecting the records
When dragging a field in Design view to move it, a _____ will display on the pointer and a[n] _____ will indicate its new position.
gray square; thick black line
What are you asked to specify in the first Lookup Wizard dialog box?
how you want your lookup column to get its values
When applying formatting in Datasheet view, the formatting buttons [Bold, Italic, Underline, etc.] apply formatting to
all the data in the table
When Access creates a form from a table, the first column in the form contains
the label control objects.
When creating a form using the Form button, the form will display in _____ view.
Layout
In a split form, the top half of the form displays the data in _____ view while the bottom half displays the data in _____ view.
Layout; Datasheet
To add a new record to your form, click the New [blank] record button, which is located
on the Record Navigation bar.
Which of the following is not one of the quick steps for creating a report?
Click the Report Design button.
A report created with the Report button will be displayed in _____ view.
Layout
Checking the Print Data Only box in the Page Size group will cause the _____ not to print on the report.
report title and column headings
Display the structure of a database using the
Object Dependencies task pane
In which of the following groups on the Home tab will you find the Selection button?
Sort & Filter
Which of the following pieces of information cannot be recorded in the Summary tab of the Properties dialog box for an Access database?
date created
As you work with a database, data in it can become _____, causing the amount of space the database takes on a storage medium to be larger than necessary.
fragmented
Data exported from Access to Excel is saved with the _____ file extension.
.xlsx
What is the last button you click in the process of exporting an Access object to PDF?
Publish
The field used when merging data with Word is an example of a[n] _____ field.
composite
After you have filtered a table, the word Filtered appears on the
Record Navigation bar
Sets with similar termsAccess Level 1
218 terms
thompson_emily
Unit 5: Access
45 terms
Alyce_Lipham
New Perspectives Microsoft Office 365 & Office 201…
63 terms
John_DeBeer
MIS 1305 Final Review
88 terms
maddie_leigh_teakell
Sets found in the same folderAccess Chapter 1/2 SNAP PRACTICE CONCEPTS
30 terms
col_study
Chp 5. test
24 terms
cbeckwith2220
Access Chapter 4
88 terms
Emily_W627
Access CH4.
20 terms
megan_clark807
Other sets by this creatorPsyc 131 - Chapter 1
15 terms
michellerey14
Word
37 terms
michellerey14
vocab 18,19,20
30 terms
michellerey14
Vocab
30 terms
michellerey14
Verified questions
COMPUTER SCIENCE
When an object is falling because of gravity, the following formula can be used to determine the distance the object falls in a specific time period: $$ d = 1 / 2 g t ^ { 2 } $$ The variables in the formula are as follows: d is the distance in meters, g is 9.8, and t is the amount of time, in seconds, that the object has been falling. Write a function named falling_distance that accepts an object’s falling time [in seconds] as an argument. The function should return the distance, in meters, that the object has fallen during that time interval. Write a program that calls the function in a loop that passes the values 1 through 10 as arguments and displays the return value.
Verified answer
COMPUTER SCIENCE
T F If you leave an element uninitialized, you do not have to leave all the ones that follow it uninitialized.
Verified answer
COMPUTER SCIENCE
Consider a computer system in which computer games can be played by students only between 10 P.M. and 6 A.M., by faculty members between 5 P.M. and 8 A.M., and by the computer center staff at all times. Suggest a scheme for implementing this policy efficiently.
Verified answer
COMPUTER SCIENCE
After the following statement executes, what elements will be stored in the myset set? myset = set['Saturn']
Verified answer
Recommended textbook solutionsComputer Organization and Design MIPS Edition: The Hardware/Software Interface
5th EditionDavid A. Patterson, John L. Hennessy
220 solutions
Service Management: Operations, Strategy, and Information Technology
7th EditionJames Fitzsimmons, Mona Fitzsimmons
103 solutions
Information Technology Project Management: Providing Measurable Organizational Value
5th EditionJack T. Marchewka
346 solutions
Introduction to Algorithms
3rd EditionCharles E. Leiserson, Clifford Stein, Ronald L. Rivest, Thomas H. Cormen
720 solutions
Other Quizlet setsbb4 psych 001
13 terms
charvey355
Verben mit Präpositionen [mit dem Dativ]
101 terms
rvasileva
Exam 1: Heart
59 terms
R_Costanzo
Nature's Architect Light Vocab
17 terms
nielsman2000
Related questionsQUESTION
Suppose that you have an Access table named Vendors with the fields "Vendor_Name", "Address", "City", "AP Balance" and "Due_Date". How might you design a query to find out the vendors who have a negative AP Balance amount?:
9 answers
QUESTION
A *correlated subquery* can occur in the *SELECT* clause of a SQL statement.
15 answers
QUESTION
During the year, Hauser Co. wrote off a customer's account receivable. Hauser used the allowance method for credit losses on accounts receivable. What impact would the write-off have on net income and total assets?
3 answers
QUESTION
User-defined functions can improve system performance because they will be processed as sets rather than individually, thus reducing system overhead.
15 answers