thinQmaster Virtual testing partner Adaptive practice exams that find your weak spots and drill them. Every answer explained. From $69
Enroll

thinQmaster

Find your exam

Five questions free, before you decide.

Step 1 · choose a vendor

In one of our camps? Your practice exams come with the tuition — they are on your study page already.

Data & Analytics · Foundational

Merge Queries

A Power Query operation that joins two queries horizontally on matching columns, like a SQL join.

Definition

Join kinds are left outer, right outer, full outer, inner, left anti and right anti. Fuzzy matching can join on similar text values. The result is a nested table column that you expand.

Exam tip

Merge = join (adds columns); Append = union (adds rows).

Related terms