Blending & structuring — quiz

Which anchor holds rows that matched on both sides?

1. L
2. J
3. R
4. All three

Answer: J — J is the inner join result.

J contains more rows than the left input had. This means:

1. Normal
2. Duplicate keys on the right caused a fan-out
3. Rows were lost
4. Wrong data type

Answer: Duplicate keys on the right caused a fan-out — Summarize the right input by the key first.

Union set to "by position" with differently ordered columns:

1. Errors
2. Silently puts values in the wrong fields
3. Matches by name anyway
4. Drops the file

Answer: Silently puts values in the wrong fields — Use by name unless you have a specific reason.

Append Fields with 10 target and 5 source rows outputs:

1. 10
2. 15
3. 50
4. 5

Answer: 50 — It is a Cartesian product — intended for a single parameter row.

Which converts month columns into month rows?

1. Cross Tab
2. Transpose
3. Union
4. Append Fields

Answer: Transpose — Transpose is the unpivot.

Your Cross Tab columns are in the wrong order because:

1. A bug
2. Cross Tab sorts new columns alphabetically
3. Wrong aggregation
4. Missing Sort tool

Answer: Cross Tab sorts new columns alphabetically — Prefix with a number before pivoting.

A field vanished after Summarize. Why?

1. A bug
2. It was neither grouped by nor aggregated
3. Wrong type
4. It was null

Answer: It was neither grouped by nor aggregated — Group by it, or aggregate with First.

Which tool gives a running total?

1. Summarize
2. Multi-Row Formula
3. Cross Tab
4. Append Fields

Answer: Multi-Row Formula — And it needs a Sort before it, since it depends on row order.