Spreadsheet: 884483d1733677885-replicate-rows-in-results-tools_table_joins
Sheet: Formula

 |  |  |  |  |  |  |  |  | tools appear in list once
 |  |  |  |  |  |  |  |  | 9 records
JOB | product | STORE | type | COST a | RESTOCK
51 | DULUX WHITE | WICKES | material | 25 | 2027-01-31 00:00:00 | material 1st job
51 | CROWN WHITE | WICKES | material | 25 | 2027-02-01 00:00:00 | material 1st job
51 | BRUSHES | WICKES | tool | 5 | 2026-05-01 00:00:00 | tool 1st job
51 | TURPS | WICKES | tool | 7.99 | 2026-05-02 00:00:00 | tool 1st job
51 | MASKING TAPE | B & Q | tool | 6 | 2026-05-03 00:00:00 | tool 1st job
52 | JONSONS BLUE | WICKES | material | 25 | 2027-02-02 00:00:00 | material 2nd job
52 | DULUX CREAM | WICKES | material | 25 | 2027-02-03 00:00:00 | material 2nd job
52 | TURPS | WICKES | tool | 7.99 | 2026-05-02 00:00:00 | tool 2nd Job
52 | MASKING TAPE | B & Q | tool | 6 | 2026-05-03 00:00:00 | tool 2nd Job
 |  |  |  |  |  |  |  |  | Tool list are replicated for every job
RESULT |  |  |  |  |  |  |  |  | 14 records
JOB | product | STORE | Type | COST a | RESTOCK |  |  |  | SORTBY-TOCOL-IFS: |  |  |  |  |  |  | REDUCE-MAP-BYROW:
51 | DULUX WHITE | WICKES | Material | 25 | 2027-01-31 00:00:00 | material 1st job |  |  |  | DULUX WHITE | WICKES | material | 25 | 2027-01-31 00:00:00 |  |  | DULUX WHITE | WICKES | material | 25 | 2027-01-31 00:00:00
51 | BRUSHES | WICKES | tool | 5 | 2026-05-01 00:00:00 | tool 1st job |  |  | 51 | BRUSHES | WICKES | tool | 5 | 2026-05-01 00:00:00 |  | 51 | BRUSHES | WICKES | tool | 5 | 2026-05-01 00:00:00
51 | TURPS | WICKES | tool | 7.99 | 2026-05-02 00:00:00 | tool 1st job |  |  | 51 | TURPS | WICKES | tool | 7.99 | 2026-05-02 00:00:00 |  | 51 | TURPS | WICKES | tool | 7.99 | 2026-05-02 00:00:00
51 | MASKING TAPE | B & Q | tool | 6 | 2026-05-03 00:00:00 | tool 1st job |  |  | 51 | MASKING TAPE | B & Q | tool | 6 | 2026-05-03 00:00:00 |  | 51 | MASKING TAPE | B & Q | tool | 6 | 2026-05-03 00:00:00
51 | CROWN WHITE | WICKES | Material | 25 | 2027-02-01 00:00:00 | material 1st job |  |  | 51 | CROWN WHITE | WICKES | material | 25 | 2027-02-01 00:00:00 |  | 51 | CROWN WHITE | WICKES | material | 25 | 2027-02-01 00:00:00
51 | BRUSHES | WICKES | tool | 5 | 2026-05-01 00:00:00 | tool 1st job |  |  | 51 | BRUSHES | WICKES | tool | 5 | 2026-05-01 00:00:00 |  | 51 | BRUSHES | WICKES | tool | 5 | 2026-05-01 00:00:00
51 | TURPS | WICKES | tool | 7.99 | 2026-05-02 00:00:00 | tool 1st job |  |  | 51 | TURPS | WICKES | tool | 7.99 | 2026-05-02 00:00:00 |  | 51 | TURPS | WICKES | tool | 7.99 | 2026-05-02 00:00:00
51 | MASKING TAPE | B & Q | tool | 6 | 2026-05-03 00:00:00 | tool 1st job |  |  | 51 | MASKING TAPE | B & Q | tool | 6 | 2026-05-03 00:00:00 |  | 51 | MASKING TAPE | B & Q | tool | 6 | 2026-05-03 00:00:00
52 | JONSONS BLUE | WICKES | Material | 25 | 2027-02-02 00:00:00 | material 2nd |  |  | 52 | JONSONS BLUE | WICKES | material | 25 | 2027-02-02 00:00:00 |  | 52 | JONSONS BLUE | WICKES | material | 25 | 2027-02-02 00:00:00
52 | TURPS | WICKES | tool | 7.99 | 2026-05-02 00:00:00 | tools 2nd job |  |  | 52 | TURPS | WICKES | tool | 7.99 | 2026-05-02 00:00:00 |  | 52 | TURPS | WICKES | tool | 7.99 | 2026-05-02 00:00:00
52 | MASKING TAPE | B & Q | tool | 6 | 2026-05-03 00:00:00 | tools 2nd job |  |  | 52 | MASKING TAPE | B & Q | tool | 6 | 2026-05-03 00:00:00 |  | 52 | MASKING TAPE | B & Q | tool | 6 | 2026-05-03 00:00:00
52 | DULUX CREAM | WICKES | Material | 25 | 2027-02-03 00:00:00 | material 2nd |  |  | 52 | DULUX CREAM | WICKES | material | 25 | 2027-02-03 00:00:00 |  | 52 | DULUX CREAM | WICKES | material | 25 | 2027-02-03 00:00:00
52 | TURPS | WICKES | tool | 7.99 | 2026-05-02 00:00:00 | tools 2nd job |  |  | 52 | TURPS | WICKES | tool | 7.99 | 2026-05-02 00:00:00 |  | 52 | TURPS | WICKES | tool | 7.99 | 2026-05-02 00:00:00
52 | MASKING TAPE | B & Q | tool | 6 | 2026-05-03 00:00:00 | tools 2nd job |  |  | 52 | MASKING TAPE | B & Q | tool | 6 | 2026-05-03 00:00:00 |  | 52 | MASKING TAPE | B & Q | tool | 6 | 2026-05-03 00:00:00