Exam (elaborations)
ALTERYX EXAM 1 QUESTIONS WITH COMPLETE SOLUTIONS
- Course
- Institution
ALTERYX EXAM 1 QUESTIONS WITH COMPLETE SOLUTIONS
[Show more]
Content preview
ALTERYX EXAM 1 QUESTIONS WITHCOMPLETE SOLUTIONS
Alteryx expressions can be used for - answer-cleansing string data, applying conditional
logic, mathematically transforming numerical values
In the alteryx formula tool, expressions are entered into the - answer-expression editor
Unique tool identifies - answer-duplicate values based on certain fields
The alteryx text to columns tool is found under which category of tools - answer-parse
Consider the regular expression \w+
What string records would not be completely identified - answer-clemson university
(because it has a space)
T/f
Both the formula tool and the multi row formula tool can a) create new columns or
modify existing columns, b) use an expression editor to input functions and c) can apply
multiple expressions per tool - answer-false; the multi row formula tool can only allow
one expression per tool
Full outer join joins records - answer-that don't correspond to the other columns (only
appears in one table)
Cartesian/cross join formula - answer-(a fields + c fields) and (b records * d records)
Structured data examples - answer-excel files and database tables
Structured data - answer-contains clearly defined fields, data types and data labels
Structured data is easy to - answer-organize into tables and search within
Semi structured data examples - answer-.csv and .txt files
Semi structured data - answer-delimiters and text quantifiers are used to create
structured data
Reg ex uses - answer-unstructured data
Unstructured data examples - answer-audio, visual, microsoft word docs, pdfs, emails,
text messages, social media data
Unstructured data is not - answer-structured via a predefined data model
, Accountants sometimes need to work with data that cannot be structured with a simple -
answer-text to column tool in excel or alteryx
Use reg ex when - answer-delimiter system isn't set up or set up inefficiently, data is
from older computer systems (multiple values in a single cell), addresses!
Reg ex allows you to - answer-extract structured data from unstructured data
With reg ex, we define - answer-recognizable patterns for software to use in order to
parse string data
Metacharacters - answer-building blocks of reg ex; have special meanings in reg ex
. - answer-wildcard; matches any alphanumeric character or symbol (letters, digits,
symbols and whitespace)
\w - answer-any letter, numeral, or underscore; alphanumeric characters
\d - answer-any whole number 0-9
\u - answer-uppercase letters
\l - answer-lowercase letters
\s - answer-whitespace
[:alpha:] - answer-only letters
\w\w\w - answer-575, dog or dog
Use of metacharacters implies - answer-1 character
Quantifiers permit flexibility to - answer-adapt to situations where the number of
characters is rigid or variable
Quantifiers follow - answer-metacharacters
Quantifier examples - answer-*, +, {#}, .*
* - answer-matches 0 or more times; may or may not be there
+ - answer-matches 1 or more times; makes the character match mandatory
{#} - answer-rigid number; matches # times
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller biggdreamer. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $12.49. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
80562 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now