Toggle navigation
GoSkills
Courses
Courses
Train your organization
Supercharge your organization with expert-led business and productivity courses.
Learn more
Learn on your own
Earn certifications for the most in-demand skills with unlimited access to all GoSkills courses.
Learn more
Explore our courses
Browse our award-winning library of 110+ business and productivity courses delivered in bite-sized lessons.
Explore courses
LMS
Course builder
Resources
Pricing
Organization pricing
Individual pricing
Pricing
Search
Sign up
Log in
Log in
Signup
Quiz
1
Intermediate
How do you merge two columns in a query while still keeping the original two columns in the table?
Go to Add Column ⇒ Merge Columns
Go to Transform ⇒ Merge Columns
Go to Add Columns ⇒ Custom Column
Don’t know
2
Intermediate
How do you use a dash (-) as the delimiter in a merged column?
Selecting Custom Delimiter from the list will allow you to enter a dash (-)
You cannot use a dash
The dash (-) character is on the drop down list of default options
Don’t know
3
Intermediate
Why is the order in which you select columns for a merge important?
Because the data type of the first column then sets the data type of the new column.
Because it ensures you do not miss adding any of the columns to be merged
The order they are selected becomes the order in which they appear in the new merged column
Don’t know
Back to the top
© 2024 GoSkills Ltd.
Skills for career advancement