Alteryx-Core Data Manipulation Practice Question
When using the Join tool, what happens to records that do not have a match in the other input?
⚠ Common exam trap
Many candidates assume unmatched records are completely deleted or discarded by the Join tool, forgetting they are simply redirected to separate output anchors.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
They are routed to the 'L' and 'R' output anchors.
The Join tool has three output anchors: J (Joined), L (Left unjoined), and R (Right unjoined). Records without a match are routed to the L and R outputs depending on which input stream they originated from. This functionality is crucial for identifying missing keys or data anomalies during the merging process. Managing these unjoined records is a standard part of data quality assurance, ensuring that no data is silently dropped during complex relational merges.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
They are automatically deleted from the workflow.
Why it's wrong here
Alteryx does not silently delete records. Records that do not find a match are explicitly routed to the L (Left unjoined) or R (Right unjoined) output anchors. This allows the developer to inspect, debug, or union those records back into the stream if they choose to do so.
- ✗
They are kept in the 'J' output but filled with nulls.
Why it's wrong here
The 'J' output only contains records where a match was found in both input streams. Records that fail to find a match are never sent to the 'J' output. Instead, they are directed to the separate unjoined anchors, ensuring that the 'J' output remains clean for matched data.
- ✓
They are routed to the 'L' and 'R' output anchors.
Why this is correct
The Join tool provides separate anchors for unjoined data. The L anchor captures records from the left input that had no match in the right input, and the R anchor captures records from the right input that had no match in the left input, providing total visibility into the join.
- ✗
They are moved to the top of the 'J' output.
Why it's wrong here
The 'J' output is strictly for records that successfully matched. Unjoined records are not included in this stream. Moving them to the 'J' output would contradict the definition of a join, which is to return only data that satisfies the intersection condition of the specified join keys.
About these practice questions
This Alteryx-Core question is part of Courseiva's 142-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam dumps. Learn why practice questions differ from exam dumps →
JA
Written and reviewed by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
Last reviewed September 2026 · checked against the official Alteryx exam blueprint
This Alteryx-Core practice question is part of Courseiva's free Alteryx certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the Alteryx-Core exam.