Join orders to customers without matching blanks
Input table:Inputs are read-only. Every step works on a copy.
| # | ||
|---|---|---|
| 1 | oz2w7 | missing |
| 2 | of1nx | C076 |
| 3 | okyr4 | ·· (raw value " ") |
| 4 | olohu | C031 |
| 5 | olfmk | C031 |
| 6 | okpom | ·C021⇥ (raw value " C021\t") |
| 7 | ogp5l | missing |
| 8 | ofluk | C076 |
| 9 | oo7yv | missing |
Preview · this dataset, in your browser, not a grade
Final output not ready yet: column "segment" does not exist. Add steps that produce every output column, or adjust them in Final output.
Check answer · graded on the server, including datasets you can't see
Press Check answer when you're ready. Your pipeline runs on the visible data and on hidden datasets that follow the same rules.
Learn from this exercise
A worked solution becomes available after your first check or once you've used every hint.