Cleaning & preparation — quiz

Which type should hold a currency amount?

1. Double
2. Fixed Decimal
3. Float
4. V_String

Answer: Fixed Decimal — Floating point accumulates rounding error across many rows.

You shorten a V_String from 255 to 50. What happens to longer values?

1. An error stops the workflow
2. They are silently truncated
3. They are nulled
4. The size auto-adjusts

Answer: They are silently truncated — Check the warnings tab after type changes.

[Revenue] - [Discount] returns null on some rows because:

1. Wrong type
2. Discount is null on those rows
3. The field is too small
4. Formula order

Answer: Discount is null on those rows — Guard with IsNull or use Data Cleansing.

To trim whitespace from twenty text fields:

1. Twenty Formula expressions
2. Multi-Field Formula
3. Select tool
4. Sort tool

Answer: Multi-Field Formula — [_CurrentField_] stands in for each selected field.

Why attach a Browse to the Filter F output?

1. To improve speed
2. To see what was excluded and verify the condition
3. It is required
4. To sort the data

Answer: To see what was excluded and verify the condition — Silent over-filtering is a common defect.

Your join matches nothing on values that look identical. Fix:

1. Change join type
2. Data Cleansing to trim whitespace and normalise case
3. Add a Sort
4. Use Append Fields

Answer: Data Cleansing to trim whitespace and normalise case — Whitespace and case are the usual culprits.