Set Field has 79 items but changed to 77 items after Summarize

Questions
1

Hi everyone! Im new to n8n and im trying to create a workflow that takes quantity takeoffs from google sheets that is then sent to specific suppliers depending on the CSI division they belong to for RFQ. However, I am stuck at the data cleaning part. The number of items went from 79 to 77 and I think I can see where the missing two are but I dont know what it means. I would really appreciate a layman’s explanation and solution for this. Thank you!!

Screenshot 2026-01-08 155604
Screenshot 2026-01-08 1556042505×1331 426 KB

Please share your workflow

Share the output returned by the last node

[
{
“appended_CSI_Division”: [
“MASONRY”
],
“Unit”: “Block(s)”,
“Quantity”: 4995,
“‘Size/Measurement’”: “8" x 8" x 16"”,
“‘Material_’”: “CMU Block”
},
{
“appended_CSI_Division”: [
“MASONRY”
],
“Unit”: “Block(s)”,
“Quantity”: 762,
“‘Size/Measurement’”: “8" x 8" x 16"”,
“‘Material_’”: “Bond Beam Block”
},
{
“appended_CSI_Division”: [
“MASONRY”
],
“Unit”: “Bag(s)”,
“Quantity”: 523.04,
“‘Size/Measurement’”: “11 Blocks/ Bag, 80 LB Bag”,
“‘Material_’”: “Block Mortar”
},
{
“appended_CSI_Division”: [
“MASONRY”
],
“Unit”: “Ton(s)”,
“Quantity”: 28.76,
“‘Size/Measurement’”: “200 Blocks/Ton”,
“‘Material_’”: “Brick Sand”
},
{
“appended_CSI_Division”: [
“MASONRY”
],
“Unit”: “CU YD”,
“Quantity”: 28.99,
“‘Size/Measurement’”: “0.34 CUYD/100 SQFT Wall, 4000 PSI”,
“‘Material_’”: “Grout”
},
{
“appended_CSI_Division”: [
“MASONRY”
],
“Unit”: “FT”,
“Quantity”: 3883.83,
“‘Size/Measurement’”: “9 Gage 304SS,”,
“‘Material_’”: “Ladder Wire”
},
{
“appended_CSI_Division”: [
“MASONRY”
],
“Unit”: “FT”,
“Quantity”: 1698.31,
“‘Size/Measurement’”: “#5 Rebar, 1.04 LBS/FT”,
“‘Material_’”: “Rebar”
},
{
“appended_CSI_Division”: [
“LUMBER”
],
“Unit”: “EA”,
“Quantity”: 557,
“‘Size/Measurement’”: “2 x 4”,
“‘Material_’”: “Lumber Pre-Cut”
},
{
“appended_CSI_Division”: [
“LUMBER”
],
“Unit”: “EA”,
“Quantity”: 32,
“‘Size/Measurement’”: “2 x 6”,
“‘Material_’”: “Lumber Pre-Cut”
},
{
“appended_CSI_Division”: [
“LUMBER”
],
“Unit”: “EA”,
“Quantity”: 17,
“‘Size/Measurement’”: “2 x 4”,
“‘Material_’”: “Lumber P.T.”
},
{
“appended_CSI_Division”: [
“LUMBER”
],
“Unit”: “EA”,
“Quantity”: 1,
“‘Size/Measurement’”: “2 x 6”,
“‘Material_’”: “Lumber P.T.”
},
{
“appended_CSI_Division”: [
“LUMBER”
],
“Unit”: “EA”,
“Quantity”: 35,
“‘Size/Measurement’”: “2 x 6”,
“‘Material_’”: “Lumber P.T.”
},
{
“appended_CSI_Division”: [
“LUMBER”,
“LUMBER”
],
“Unit”: “EA”,
“Quantity”: 6,
“‘Size/Measurement’”: “2 x 8”,
“‘Material_’”: “Lumber P.T.”
},
{
“appended_CSI_Division”: [
“LUMBER”
],
“Unit”: “EA”,
“Quantity”: 32,
“‘Size/Measurement’”: “3’-3 x 10”,
“‘Material_’”: “Lumber P.T.”
},
{
“appended_CSI_Division”: [
“LUMBER”
],
“Unit”: “EA”,
“Quantity”: 34,
“‘Size/Measurement’”: “3’-3 x 7 3/4”,
“‘Material_’”: “Lumber P.T.”
},
{
“appended_CSI_Division”: [
“LUMBER”,
“LUMBER”
],
“Unit”: “EA”,
“Quantity”: 17,
“‘Size/Measurement’”: “2 x 4”,
“‘Material_’”: “Lumber”
},
{
“appended_CSI_Division”: [
“LUMBER”
],
“Unit”: “EA”,
“Quantity”: 96,
“‘Size/Measurement’”: “2 x 4”,
“‘Material_’”: “Lumber”
},
{
“appended_CSI_Division”: [
“LUMBER”
],
“Unit”: “EA”,
“Quantity”: 5,
“‘Size/Measurement’”: “2 x 6”,
“‘Material_’”: “Lumber”
},
{
“appended_CSI_Division”: [
“LUMBER”
],
“Unit”: “EA”,
“Quantity”: 9,
“‘Size/Measurement’”: “2 x 12”,
“‘Material_’”: “Lumber”
},
{
“appended_CSI_Division”: [
“LUMBER”
],
“Unit”: “EA”,
“Quantity”: 24,
“‘Size/Measurement’”: “(2) 2 x 8”,
“‘Material_’”: “Lumber”
},
{
“appended_CSI_Division”: [
“LUMBER”
],
“Unit”: “EA”,
“Quantity”: 33,
“‘Size/Measurement’”: “2 x 8”,
“‘Material_’”: “Lumber”
},
{
“appended_CSI_Division”: [
“LUMBER”
],
“Unit”: “EA”,
“Quantity”: 16,
“‘Size/Measurement’”: “16 FT Length”,
“‘Material_’”: “Lumber 24" Deep LSL”
},
{
“appended_CSI_Division”: [
“LUMBER”
],
“Unit”: “EA”,
“Quantity”: 4,
“‘Size/Measurement’”: “4 FT Length”,
“‘Material_’”: “24" Deep Pre-Engineered Floor Trusses”
},
{
“appended_CSI_Division”: [
“LUMBER”
],
“Unit”: “EA”,
“Quantity”: 4,
“‘Size/Measurement’”: “12 FT Length”,
“‘Material_’”: “24" Deep Pre-Engineered Floor Trusses”
},
{
“appended_CSI_Division”: [
“LUMBER”
],
“Unit”: “EA”,
“Quantity”: 55,
“‘Size/Measurement’”: “30 FT Length”,
“‘Material_’”: “24" Deep Pre-Engineered Floor Trusses”
},
{
“appended_CSI_Division”: [
“LUMBER”
],
“Unit”: “EA”,
“Quantity”: 30,
“‘Size/Measurement’”: “36 FT Length”,
“‘Material_’”: “Pre-Engineered Roof Trusses”
},
{
“appended_CSI_Division”: [
“LUMBER”
],
“Unit”: “EA”,
“Quantity”: 12,
“‘Size/Measurement’”: “40 FT Length”,
“‘Material_’”: “Pre-Engineered Roof Trusses”
},
{
“appended_CSI_Division”: [
“LUMBER”
],
“Unit”: “EA”,
“Quantity”: 70,
“‘Size/Measurement’”: “3/4"x4’ x 8’”,
“‘Material_’”: “3/4" PT Sub-Floor Plywood Floor Sheathing”
},
{
“appended_CSI_Division”: [
“LUMBER”
],
“Unit”: “EA”,
“Quantity”: 100,
“‘Size/Measurement’”: “3/4"x4’ x 8’”,
“‘Material_’”: “3/4" PT CDX Plywood Roof Sheathing”
},
{
“appended_CSI_Division”: [
“LUMBER”
],
“Unit”: “SQFT”,
“Quantity”: 94,
“‘Size/Measurement’”: “”,
“‘Material_’”: “Composite Balcony Floor Decking”
},
{
“appended_CSI_Division”: [
“LUMBER”
],
“Unit”: “FT”,
“Quantity”: 74,
“‘Size/Measurement’”: “”,
“‘Material_’”: “36" High Stair Guardrail”
},
{
“appended_CSI_Division”: [
“LUMBER”
],
“Unit”: “FT”,
“Quantity”: 38,
“‘Size/Measurement’”: “”,
“‘Material_’”: “42" High Balcony Guardrail”
},
{
“appended_CSI_Division”: [
“THERMAL & MOISTURE PROTECTION”
],
“Unit”: “BUNDLE”,
“Quantity”: 33.26,
“‘Size/Measurement’”: “100 SQ.FT. / Bundle, 25 Yr”,
“‘Material_’”: “Asphalt Shingle”
},
{
“appended_CSI_Division”: [
“THERMAL & MOISTURE PROTECTION”
],
“Unit”: “Roll(s)”,
“Quantity”: 8.32,
“‘Size/Measurement’”: “400 SQ FT / Roll, 15#”,
“‘Material_’”: “Asphalt Felt”
},
{
“appended_CSI_Division”: [
“THERMAL & MOISTURE PROTECTION”
],
“Unit”: “EA”,
“Quantity”: 5.93,
“‘Size/Measurement’”: “10’ Lengths”,
“‘Material_’”: “Ridge Flashing”
},
{
“appended_CSI_Division”: [
“THERMAL & MOISTURE PROTECTION”
],
“Unit”: “Bundles”,
“Quantity”: 1.8,
“‘Size/Measurement’”: “”,
“‘Material_’”: “Ridge Shingles”
},
{
“appended_CSI_Division”: [
“THERMAL & MOISTURE PROTECTION”
],
“Unit”: “Roll(s)”,
“Quantity”: 6.67,
“‘Size/Measurement’”: “3’ X 75’”,
“‘Material_’”: “Ice and Water Shield”
},
{
“appended_CSI_Division”: [
“THERMAL & MOISTURE PROTECTION”
],
“Unit”: “EA”,
“Quantity”: 5.93,
“‘Size/Measurement’”: “10’ Lengths”,
“‘Material_’”: “Ridge Vent”
},
{
“appended_CSI_Division”: [
“THERMAL & MOISTURE PROTECTION”
],
“Unit”: “EA”,
“Quantity”: 3.72,
“‘Size/Measurement’”: “12 Widths, 10’ Lengths”,
“‘Material_’”: “Valley Flashing”
},
{
“appended_CSI_Division”: [
“THERMAL & MOISTURE PROTECTION”
],
“Unit”: “EA”,
“Quantity”: 14.07,
“‘Size/Measurement’”: “12 Widths, 10’ Lengths”,
“‘Material_’”: “Hip Flashing”
},
{
“appended_CSI_Division”: [
“THERMAL & MOISTURE PROTECTION”
],
“Unit”: “Bundles”,
“Quantity”: 4.26,
“‘Size/Measurement’”: “”,
“‘Material_’”: “Hip Shingles”
},
{
“appended_CSI_Division”: [
“THERMAL & MOISTURE PROTECTION”
],
“Unit”: “BNDLS”,
“Quantity”: 2.63,
“‘Size/Measurement’”: “”,
“‘Material_’”: “Starter Shingles”
},
{
“appended_CSI_Division”: [
“THERMAL & MOISTURE PROTECTION”
],
“Unit”: “EA”,
“Quantity”: 16.42,
“‘Size/Measurement’”: “1X6, 16’ Length”,
“‘Material_’”: “Fascia Board”
},
{
“appended_CSI_Division”: [
“THERMAL & MOISTURE PROTECTION”
],
“Unit”: “EA”,
“Quantity”: 26.27,
“‘Size/Measurement’”: “2.5 X 1.5”,
“‘Material_’”: “Metal Drip Edge”
},
{
“appended_CSI_Division”: [
“THERMAL & MOISTURE PROTECTION”
],
“Unit”: “EA”,
“Quantity”: 88,
“‘Size/Measurement’”: “spaced at 3’ o.c.”,
“‘Material_’”: “Gutter Hanger”
},
{
“appended_CSI_Division”: [
“THERMAL & MOISTURE PROTECTION”
],
“Unit”: “EA”,
“Quantity”: 26.27,
“‘Size/Measurement’”: “spaced at 3’ o.c.”,
“‘Material_’”: “Gutter”
},
{
“appended_CSI_Division”: [
“THERMAL & MOISTURE PROTECTION”
],
“Unit”: “EA”,
“Quantity”: 58.86,
“‘Size/Measurement’”: “1’ x 12’”,
“‘Material_’”: “Ceiling Soffit”
},
{
“appended_CSI_Division”: [
“THERMAL & MOISTURE PROTECTION”
],
“Unit”: “FT”,
“Quantity”: 45.53,
“‘Size/Measurement’”: “1’ x 12’, 12’ 6’’ Lengths”,
“‘Material_’”: “F-Channel”
},
{
“appended_CSI_Division”: [
“THERMAL & MOISTURE PROTECTION”
],
“Unit”: “EA”,
“Quantity”: 12,
“‘Size/Measurement’”: “(None)”,
“‘Material_’”: “Roof Drain”
},
{
“appended_CSI_Division”: [
“THERMAL & MOISTURE PROTECTION”
],
“Unit”: “EA”,
“Quantity”: 12,
“‘Size/Measurement’”: “(None)”,
“‘Material_’”: “Clamping Ring and strainer”
},
{
“appended_CSI_Division”: [
“THERMAL & MOISTURE PROTECTION”
],
“Unit”: “EA”,
“Quantity”: 12,
“‘Size/Measurement’”: “(None)”,
“‘Material_’”: “Water Block Flashing”
},
{
“appended_CSI_Division”: [
“THERMAL & MOISTURE PROTECTION”
],
“Unit”: “EA”,
“Quantity”: 353,
“‘Size/Measurement’”: “4’ X10’ Sheets”,
“‘Material_’”: “Board”
},
{
“appended_CSI_Division”: [
“THERMAL & MOISTURE PROTECTION”
],
“Unit”: “FT”,
“Quantity”: 2615.67,
“‘Size/Measurement’”: “2 Batten”,
“‘Material_’”: “Batten”
},
{
“appended_CSI_Division”: [
“THERMAL & MOISTURE PROTECTION”
],
“Unit”: “Rolls”,
“Quantity”: 2.71,
“‘Size/Measurement’”: “9’ X 150’ Rolls”,
“‘Material_’”: “Moisture Barrier”
},
{
“appended_CSI_Division”: [
“THERMAL & MOISTURE PROTECTION”
],
“Unit”: “EA”,
“Quantity”: 254,
“‘Size/Measurement’”: “10’ Length”,
“‘Material_’”: “Metal Furring”
},
{
“appended_CSI_Division”: [
“THERMAL & MOISTURE PROTECTION”
],
“Unit”: “EA”,
“Quantity”: 22.74,
“‘Size/Measurement’”: “10’ Length (Assumed)”,
“‘Material_’”: “Flashing”
},
{
“appended_CSI_Division”: [
“THERMAL & MOISTURE PROTECTION”
],
“Unit”: “Roll(s)”,
“Quantity”: 11.69,
“‘Size/Measurement’”: “50’ Rolls”,
“‘Material_’”: “Flashing Tape”
},
{
“appended_CSI_Division”: [
“THERMAL & MOISTURE PROTECTION”
],
“Unit”: “EA”,
“Quantity”: 15.65,
“‘Size/Measurement’”: “10’ Length (Assumed)”,
“‘Material_’”: “Drip Edge Flashing”
},
{
“appended_CSI_Division”: [
“THERMAL & MOISTURE PROTECTION”
],
“Unit”: “EA”,
“Quantity”: 20.93,
“‘Size/Measurement’”: “10’ Length”,
“‘Material_’”: “Flashing (Weep Screed)”
},
{
“appended_CSI_Division”: [
“THERMAL & MOISTURE PROTECTION”
],
“Unit”: “EA”,
“Quantity”: 9,
“‘Size/Measurement’”: “50 sq.ft /Roll”,
“‘Material_’”: “Insulation”
},
{
“appended_CSI_Division”: [
“THERMAL & MOISTURE PROTECTION”
],
“Unit”: “EA”,
“Quantity”: 80,
“‘Size/Measurement’”: “50 sq.ft /Roll”,
“‘Material_’”: “Insulation”
},
{
“appended_CSI_Division”: [
“THERMAL & MOISTURE PROTECTION”
],
“Unit”: “EA”,
“Quantity”: 66,
“‘Size/Measurement’”: “50 sq.ft /Roll”,
“‘Material_’”: “Insulation”
},
{
“appended_CSI_Division”: [
“THERMAL & MOISTURE PROTECTION”
],
“Unit”: “SQ FT”,
“Quantity”: 3215.98,
“‘Size/Measurement’”: “50 sq.ft /Roll”,
“‘Material_’”: “Insulation”
},
{
“appended_CSI_Division”: [
“THERMAL & MOISTURE PROTECTION”
],
“Unit”: “Roll(s)”,
“Quantity”: 45.89,
“‘Size/Measurement’”: “50 sq.ft /Roll”,
“‘Material_’”: “Insulation”
},
{
“appended_CSI_Division”: [
“FINISHES”
],
“Unit”: “EA”,
“Quantity”: 54,
“‘Size/Measurement’”: “1/2’’ THK , 4’ x 10’ Sheets”,
“‘Material_’”: “MR (Green Board) Gypsum Wall Board”
},
{
“appended_CSI_Division”: [
“FINISHES”
],
“Unit”: “EA”,
“Quantity”: 70,
“‘Size/Measurement’”: “5/8 , 4’ x 10’ Sheets”,
“‘Material_’”: “MR (Green Board) Gypsum Wall Board”
},
{
“appended_CSI_Division”: [
“FINISHES”
],
“Unit”: “EA”,
“Quantity”: 28,
“‘Size/Measurement’”: “5/8’’ THK, 4’ x 10’ Sheets”,
“‘Material_’”: “Type X Gypsum Wall Board”
},
{
“appended_CSI_Division”: [
“FINISHES”
],
“Unit”: “EA”,
“Quantity”: 388,
“‘Size/Measurement’”: “1/2’’ THK, 4’ x 10’ Sheets”,
“‘Material_’”: “Regular Gypsum Wall Board”
},
{
“appended_CSI_Division”: [
“FINISHES”
],
“Unit”: “EA”,
“Quantity”: 36,
“‘Size/Measurement’”: “1/2’’ THK, 4’ x 8’ Sheets”,
“‘Material_’”: “Tile backer board”
},
{
“appended_CSI_Division”: [
“FINISHES”
],
“Unit”: “EA”,
“Quantity”: 24.44,
“‘Size/Measurement’”: “250’ Roll”,
“‘Material_’”: “Joint Tape”
},
{
“appended_CSI_Division”: [
“FINISHES”
],
“Unit”: “EA”,
“Quantity”: 25.84,
“‘Size/Measurement’”: “4.5 Gal Joint Compound”,
“‘Material_’”: “Joint Compound”
},
{
“appended_CSI_Division”: [
“FINISHES”
],
“Unit”: “EA”,
“Quantity”: 1.4,
“‘Size/Measurement’”: “250’ Roll”,
“‘Material_’”: “Fire Tape”
},
{
“appended_CSI_Division”: [
“FINISHES”
],
“Unit”: “Box(s)”,
“Quantity”: 7.96,
“‘Size/Measurement’”: “#8 2 Screws Box Size: 5000 Qty”,
“‘Material_’”: “Drywall Screws”
},
{
“appended_CSI_Division”: [
“FINISHES”
],
“Unit”: “FT”,
“Quantity”: 3254,
“‘Size/Measurement’”: “1-5/8 16’’ O.C”,
“‘Material_’”: “Light Gage Galvanized Furring Channel”
},
{
“appended_CSI_Division”: [
“FINISHES”
],
“Unit”: “EA”,
“Quantity”: 181.2,
“‘Size/Measurement’”: “10’ Lengths”,
“‘Material_’”: “Inside Bead”
},
{
“appended_CSI_Division”: [
“FINISHES”
],
“Unit”: “EA”,
“Quantity”: 26.8,
“‘Size/Measurement’”: “10’ Lengths”,
“‘Material_’”: “Outside Bead”
},
{
“appended_CSI_Division”: [
“FINISHES”
],
“Unit”: “EA”,
“Quantity”: 194.62,
“‘Size/Measurement’”: “10’ Lenghts”,
“‘Material_’”: “J-Beads”
}
]

Im expecting an output something like this:

(Also, Is it correct to assume that the summary should only have 4 items since I want them to be grouped by division?)

CSI Division ##
Material: x
Size/Measurement: y
Quantity: #
Unit: z

Material: x2
Size/Measurement: y2
Quantity: #2
Unit: z2
  • Database (default: SQLite):
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via npm
  • Operating system:
2

Hi @Elliemenopi, welcome!

Even though the formatting here in the forum isn’t displaying correctly, I can see there are some key names with quotes inside quotes, this might be what’s causing the issue,

image

Make sure to edit these keys to remove the extra quotes, for example change "Size/Measurement" and "Material_"

Try that and let me know if it works, If you’re still getting the same issue, please insert the JSON using code blocks (triple backticks) so I can see the exact formatting..

3

Thank you for the reply! I tried editing those but nothing’s changed :smiling_face_with_tear:

Here’s from the Edit Field:

```json
[
  {
    "CSI Division": "MASONRY",
    "Material": "CMU Block",
    "Size/Measurement": "8\" x 8\" x 16\"",
    "Quantity": 4995,
    "Unit": "Block(s)"
  },
  {
    "CSI Division": "MASONRY",
    "Material": "Bond Beam Block",
    "Size/Measurement": "8\" x 8\" x 16\"",
    "Quantity": 762,
    "Unit": "Block(s)"
  },
  {
    "CSI Division": "MASONRY",
    "Material": "Block Mortar",
    "Size/Measurement": "11 Blocks/ Bag, 80 LB Bag",
    "Quantity": 523.04,
    "Unit": "Bag(s)"
  },
  {
    "CSI Division": "MASONRY",
    "Material": "Brick Sand",
    "Size/Measurement": "200 Blocks/Ton",
    "Quantity": 28.76,
    "Unit": "Ton(s)"
  },
  {
    "CSI Division": "MASONRY",
    "Material": "Grout",
    "Size/Measurement": "0.34 CUYD/100 SQFT Wall, 4000 PSI",
    "Quantity": 28.99,
    "Unit": "CU YD"
  },
  {
    "CSI Division": "MASONRY",
    "Material": "Ladder Wire",
    "Size/Measurement": "9 Gage 304SS,",
    "Quantity": 3883.83,
    "Unit": "FT"
  },
  {
    "CSI Division": "MASONRY",
    "Material": "Rebar",
    "Size/Measurement": "#5 Rebar, 1.04 LBS/FT",
    "Quantity": 1698.31,
    "Unit": "FT"
  },
  {
    "CSI Division": "LUMBER",
    "Material": "Lumber Pre-Cut",
    "Size/Measurement": "2 x 4",
    "Quantity": 557,
    "Unit": "EA"
  },
  {
    "CSI Division": "LUMBER",
    "Material": "Lumber Pre-Cut",
    "Size/Measurement": "2 x 6",
    "Quantity": 32,
    "Unit": "EA"
  },
  {
    "CSI Division": "LUMBER",
    "Material": "Lumber P.T.",
    "Size/Measurement": "2 x 4",
    "Quantity": 17,
    "Unit": "EA"
  },
  {
    "CSI Division": "LUMBER",
    "Material": "Lumber P.T.",
    "Size/Measurement": "2 x 6",
    "Quantity": 1,
    "Unit": "EA"
  },
  {
    "CSI Division": "LUMBER",
    "Material": "Lumber P.T.",
    "Size/Measurement": "2 x 8",
    "Quantity": 6,
    "Unit": "EA"
  },
  {
    "CSI Division": "LUMBER",
    "Material": "Lumber P.T.",
    "Size/Measurement": "2 x 8",
    "Quantity": 6,
    "Unit": "EA"
  },
  {
    "CSI Division": "LUMBER",
    "Material": "Lumber P.T.",
    "Size/Measurement": "3'-3 x 10",
    "Quantity": 32,
    "Unit": "EA"
  },
  {
    "CSI Division": "LUMBER",
    "Material": "Lumber P.T.",
    "Size/Measurement": "3'-3 x 7 3/4",
    "Quantity": 34,
    "Unit": "EA"
  },
  {
    "CSI Division": "LUMBER",
    "Material": "Lumber",
    "Size/Measurement": "2 x 4",
    "Quantity": 17,
    "Unit": "EA"
  },
  {
    "CSI Division": "LUMBER",
    "Material": "Lumber",
    "Size/Measurement": "2 x 4",
    "Quantity": 96,
    "Unit": "EA"
  },
  {
    "CSI Division": "LUMBER",
    "Material": "Lumber",
    "Size/Measurement": "2 x 6",
    "Quantity": 5,
    "Unit": "EA"
  },
  {
    "CSI Division": "LUMBER",
    "Material": "Lumber",
    "Size/Measurement": "2 x 12",
    "Quantity": 9,
    "Unit": "EA"
  },
  {
    "CSI Division": "LUMBER",
    "Material": "Lumber",
    "Size/Measurement": "(2) 2 x 8",
    "Quantity": 24,
    "Unit": "EA"
  },
  {
    "CSI Division": "LUMBER",
    "Material": "Lumber P.T.",
    "Size/Measurement": "2 x 6",
    "Quantity": 35,
    "Unit": "EA"
  },
  {
    "CSI Division": "LUMBER",
    "Material": "Lumber",
    "Size/Measurement": "2 x 8",
    "Quantity": 33,
    "Unit": "EA"
  },
  {
    "CSI Division": "LUMBER",
    "Material": "Lumber",
    "Size/Measurement": "2 x 4",
    "Quantity": 17,
    "Unit": "EA"
  },
  {
    "CSI Division": "LUMBER",
    "Material": "Lumber 24\" Deep LSL",
    "Size/Measurement": "16 FT Length",
    "Quantity": 16,
    "Unit": "EA"
  },
  {
    "CSI Division": "LUMBER",
    "Material": "24\" Deep Pre-Engineered Floor Trusses",
    "Size/Measurement": "4 FT Length",
    "Quantity": 4,
    "Unit": "EA"
  },
  {
    "CSI Division": "LUMBER",
    "Material": "24\" Deep Pre-Engineered Floor Trusses",
    "Size/Measurement": "12 FT Length",
    "Quantity": 4,
    "Unit": "EA"
  },
  {
    "CSI Division": "LUMBER",
    "Material": "24\" Deep Pre-Engineered Floor Trusses",
    "Size/Measurement": "30 FT Length",
    "Quantity": 55,
    "Unit": "EA"
  },
  {
    "CSI Division": "LUMBER",
    "Material": "Pre-Engineered Roof Trusses",
    "Size/Measurement": "36 FT Length",
    "Quantity": 30,
    "Unit": "EA"
  },
  {
    "CSI Division": "LUMBER",
    "Material": "Pre-Engineered Roof Trusses",
    "Size/Measurement": "40 FT Length",
    "Quantity": 12,
    "Unit": "EA"
  },
  {
    "CSI Division": "LUMBER",
    "Material": "3/4\" PT Sub-Floor Plywood Floor Sheathing",
    "Size/Measurement": "3/4\"x4' x 8'",
    "Quantity": 70,
    "Unit": "EA"
  },
  {
    "CSI Division": "LUMBER",
    "Material": "3/4\" PT CDX Plywood Roof Sheathing",
    "Size/Measurement": "3/4\"x4' x 8'",
    "Quantity": 100,
    "Unit": "EA"
  },
  {
    "CSI Division": "LUMBER",
    "Material": "Composite Balcony Floor Decking",
    "Size/Measurement": "",
    "Quantity": 94,
    "Unit": "SQFT"
  },
  {
    "CSI Division": "LUMBER",
    "Material": "36\" High Stair Guardrail",
    "Size/Measurement": "",
    "Quantity": 74,
    "Unit": "FT"
  },
  {
    "CSI Division": "LUMBER",
    "Material": "42\" High Balcony Guardrail",
    "Size/Measurement": "",
    "Quantity": 38,
    "Unit": "FT"
  },
  {
    "CSI Division": "THERMAL & MOISTURE PROTECTION",
    "Material": "Asphalt Shingle",
    "Size/Measurement": "100 SQ.FT. / Bundle, 25 Yr",
    "Quantity": 33.26,
    "Unit": "BUNDLE"
  },
  {
    "CSI Division": "THERMAL & MOISTURE PROTECTION",
    "Material": "Asphalt Felt",
    "Size/Measurement": "400 SQ FT / Roll, 15#",
    "Quantity": 8.32,
    "Unit": "Roll(s)"
  },
  {
    "CSI Division": "THERMAL & MOISTURE PROTECTION",
    "Material": "Ridge Flashing",
    "Size/Measurement": "10' Lengths",
    "Quantity": 5.93,
    "Unit": "EA"
  },
  {
    "CSI Division": "THERMAL & MOISTURE PROTECTION",
    "Material": "Ridge Shingles",
    "Size/Measurement": "",
    "Quantity": 1.8,
    "Unit": "Bundles"
  },
  {
    "CSI Division": "THERMAL & MOISTURE PROTECTION",
    "Material": "Ice and Water Shield",
    "Size/Measurement": "3' X 75'",
    "Quantity": 6.67,
    "Unit": "Roll(s)"
  },
  {
    "CSI Division": "THERMAL & MOISTURE PROTECTION",
    "Material": "Ridge Vent",
    "Size/Measurement": "10' Lengths",
    "Quantity": 5.93,
    "Unit": "EA"
  },
  {
    "CSI Division": "THERMAL & MOISTURE PROTECTION",
    "Material": "Valley Flashing",
    "Size/Measurement": "12 Widths, 10' Lengths",
    "Quantity": 3.72,
    "Unit": "EA"
  },
  {
    "CSI Division": "THERMAL & MOISTURE PROTECTION",
    "Material": "Hip Flashing",
    "Size/Measurement": "12 Widths, 10' Lengths",
    "Quantity": 14.07,
    "Unit": "EA"
  },
  {
    "CSI Division": "THERMAL & MOISTURE PROTECTION",
    "Material": "Hip Shingles",
    "Size/Measurement": "",
    "Quantity": 4.26,
    "Unit": "Bundles"
  },
  {
    "CSI Division": "THERMAL & MOISTURE PROTECTION",
    "Material": "Starter Shingles",
    "Size/Measurement": "",
    "Quantity": 2.63,
    "Unit": "BNDLS"
  },
  {
    "CSI Division": "THERMAL & MOISTURE PROTECTION",
    "Material": "Fascia Board",
    "Size/Measurement": "1X6, 16' Length",
    "Quantity": 16.42,
    "Unit": "EA"
  },
  {
    "CSI Division": "THERMAL & MOISTURE PROTECTION",
    "Material": "Metal Drip Edge",
    "Size/Measurement": "2.5 X 1.5",
    "Quantity": 26.27,
    "Unit": "EA"
  },
  {
    "CSI Division": "THERMAL & MOISTURE PROTECTION",
    "Material": "Gutter Hanger",
    "Size/Measurement": "spaced at 3' o.c.",
    "Quantity": 88,
    "Unit": "EA"
  },
  {
    "CSI Division": "THERMAL & MOISTURE PROTECTION",
    "Material": "Gutter",
    "Size/Measurement": "spaced at 3' o.c.",
    "Quantity": 26.27,
    "Unit": "EA"
  },
  {
    "CSI Division": "THERMAL & MOISTURE PROTECTION",
    "Material": "Ceiling  Soffit",
    "Size/Measurement": "1' x 12'",
    "Quantity": 58.86,
    "Unit": "EA"
  },
  {
    "CSI Division": "THERMAL & MOISTURE PROTECTION",
    "Material": "F-Channel",
    "Size/Measurement": "1' x 12', 12' 6'' Lengths",
    "Quantity": 45.53,
    "Unit": "FT"
  },
  {
    "CSI Division": "THERMAL & MOISTURE PROTECTION",
    "Material": "Roof Drain",
    "Size/Measurement": "(None)",
    "Quantity": 12,
    "Unit": "EA"
  },
  {
    "CSI Division": "THERMAL & MOISTURE PROTECTION",
    "Material": "Clamping Ring and strainer",
    "Size/Measurement": "(None)",
    "Quantity": 12,
    "Unit": "EA"
  },
  {
    "CSI Division": "THERMAL & MOISTURE PROTECTION",
    "Material": "Water Block Flashing",
    "Size/Measurement": "(None)",
    "Quantity": 12,
    "Unit": "EA"
  },
  {
    "CSI Division": "THERMAL & MOISTURE PROTECTION",
    "Material": "Board",
    "Size/Measurement": "4' X10' Sheets",
    "Quantity": 353,
    "Unit": "EA"
  },
  {
    "CSI Division": "THERMAL & MOISTURE PROTECTION",
    "Material": "Batten",
    "Size/Measurement": "2 Batten",
    "Quantity": 2615.67,
    "Unit": "FT"
  },
  {
    "CSI Division": "THERMAL & MOISTURE PROTECTION",
    "Material": "Moisture Barrier",
    "Size/Measurement": "9' X 150' Rolls",
    "Quantity": 2.71,
    "Unit": "Rolls"
  },
  {
    "CSI Division": "THERMAL & MOISTURE PROTECTION",
    "Material": "Metal Furring",
    "Size/Measurement": "10' Length",
    "Quantity": 254,
    "Unit": "EA"
  },
  {
    "CSI Division": "THERMAL & MOISTURE PROTECTION",
    "Material": "Flashing",
    "Size/Measurement": "10' Length (Assumed)",
    "Quantity": 22.74,
    "Unit": "EA"
  },
  {
    "CSI Division": "THERMAL & MOISTURE PROTECTION",
    "Material": "Flashing Tape",
    "Size/Measurement": "50' Rolls",
    "Quantity": 11.69,
    "Unit": "Roll(s)"
  },
  {
    "CSI Division": "THERMAL & MOISTURE PROTECTION",
    "Material": "Drip Edge Flashing",
    "Size/Measurement": "10' Length (Assumed)",
    "Quantity": 15.65,
    "Unit": "EA"
  },
  {
    "CSI Division": "THERMAL & MOISTURE PROTECTION",
    "Material": "Flashing (Weep Screed)",
    "Size/Measurement": "10' Length",
    "Quantity": 20.93,
    "Unit": "EA"
  },
  {
    "CSI Division": "THERMAL & MOISTURE PROTECTION",
    "Material": "Insulation",
    "Size/Measurement": "50 sq.ft /Roll",
    "Quantity": 9,
    "Unit": "EA"
  },
  {
    "CSI Division": "THERMAL & MOISTURE PROTECTION",
    "Material": "Insulation",
    "Size/Measurement": "50 sq.ft /Roll",
    "Quantity": 80,
    "Unit": "EA"
  },
  {
    "CSI Division": "THERMAL & MOISTURE PROTECTION",
    "Material": "Insulation",
    "Size/Measurement": "50 sq.ft /Roll",
    "Quantity": 66,
    "Unit": "EA"
  },
  {
    "CSI Division": "THERMAL & MOISTURE PROTECTION",
    "Material": "Insulation",
    "Size/Measurement": "50 sq.ft /Roll",
    "Quantity": 3215.98,
    "Unit": "SQ FT"
  },
  {
    "CSI Division": "THERMAL & MOISTURE PROTECTION",
    "Material": "Insulation",
    "Size/Measurement": "50 sq.ft /Roll",
    "Quantity": 45.89,
    "Unit": "Roll(s)"
  },
  {
    "CSI Division": "FINISHES",
    "Material": "MR (Green Board) Gypsum Wall Board",
    "Size/Measurement": "1/2'' THK , 4' x 10' Sheets",
    "Quantity": 54,
    "Unit": "EA"
  },
  {
    "CSI Division": "FINISHES",
    "Material": "Type X Gypsum Wall Board",
    "Size/Measurement": "5/8'' THK,  4' x 10' Sheets",
    "Quantity": 28,
    "Unit": "EA"
  },
  {
    "CSI Division": "FINISHES",
    "Material": "Regular Gypsum Wall Board",
    "Size/Measurement": "1/2'' THK,  4' x 10' Sheets",
    "Quantity": 388,
    "Unit": "EA"
  },
  {
    "CSI Division": "FINISHES",
    "Material": "MR (Green Board) Gypsum Wall Board",
    "Size/Measurement": "5/8 , 4' x 10' Sheets",
    "Quantity": 70,
    "Unit": "EA"
  },
  {
    "CSI Division": "FINISHES",
    "Material": "Tile backer board",
    "Size/Measurement": "1/2'' THK, 4' x 8' Sheets",
    "Quantity": 36,
    "Unit": "EA"
  },
  {
    "CSI Division": "FINISHES",
    "Material": "Joint Tape",
    "Size/Measurement": "250' Roll",
    "Quantity": 24.44,
    "Unit": "EA"
  },
  {
    "CSI Division": "FINISHES",
    "Material": "Joint Compound",
    "Size/Measurement": "4.5 Gal Joint Compound",
    "Quantity": 25.84,
    "Unit": "EA"
  },
  {
    "CSI Division": "FINISHES",
    "Material": "Fire Tape",
    "Size/Measurement": "250' Roll",
    "Quantity": 1.4,
    "Unit": "EA"
  },
  {
    "CSI Division": "FINISHES",
    "Material": "Drywall Screws",
    "Size/Measurement": "#8 2 Screws Box Size: 5000 Qty",
    "Quantity": 7.96,
    "Unit": "Box(s)"
  },
  {
    "CSI Division": "FINISHES",
    "Material": "Light Gage Galvanized Furring Channel",
    "Size/Measurement": "1-5/8 16'' O.C",
    "Quantity": 3254,
    "Unit": "FT"
  },
  {
    "CSI Division": "FINISHES",
    "Material": "Inside Bead",
    "Size/Measurement": "10' Lengths",
    "Quantity": 181.2,
    "Unit": "EA"
  },
  {
    "CSI Division": "FINISHES",
    "Material": "Outside Bead",
    "Size/Measurement": "10' Lengths",
    "Quantity": 26.8,
    "Unit": "EA"
  },
  {
    "CSI Division": "FINISHES",
    "Material": "J-Beads",
    "Size/Measurement": "10' Lenghts",
    "Quantity": 194.62,
    "Unit": "EA"
  }
]
```

and from Summarize:

```json
[
  {
    "appended_CSI_Division": [
      "MASONRY"
    ],
    "Unit": "Block(s)",
    "Quantity": 4995,
    "Size/Measurement": "8\" x 8\" x 16\"",
    "Material": "CMU Block"
  },
  {
    "appended_CSI_Division": [
      "MASONRY"
    ],
    "Unit": "Block(s)",
    "Quantity": 762,
    "Size/Measurement": "8\" x 8\" x 16\"",
    "Material": "Bond Beam Block"
  },
  {
    "appended_CSI_Division": [
      "MASONRY"
    ],
    "Unit": "Bag(s)",
    "Quantity": 523.04,
    "Size/Measurement": "11 Blocks/ Bag, 80 LB Bag",
    "Material": "Block Mortar"
  },
  {
    "appended_CSI_Division": [
      "MASONRY"
    ],
    "Unit": "Ton(s)",
    "Quantity": 28.76,
    "Size/Measurement": "200 Blocks/Ton",
    "Material": "Brick Sand"
  },
  {
    "appended_CSI_Division": [
      "MASONRY"
    ],
    "Unit": "CU YD",
    "Quantity": 28.99,
    "Size/Measurement": "0.34 CUYD/100 SQFT Wall, 4000 PSI",
    "Material": "Grout"
  },
  {
    "appended_CSI_Division": [
      "MASONRY"
    ],
    "Unit": "FT",
    "Quantity": 3883.83,
    "Size/Measurement": "9 Gage 304SS,",
    "Material": "Ladder Wire"
  },
  {
    "appended_CSI_Division": [
      "MASONRY"
    ],
    "Unit": "FT",
    "Quantity": 1698.31,
    "Size/Measurement": "#5 Rebar, 1.04 LBS/FT",
    "Material": "Rebar"
  },
  {
    "appended_CSI_Division": [
      "LUMBER"
    ],
    "Unit": "EA",
    "Quantity": 557,
    "Size/Measurement": "2 x 4",
    "Material": "Lumber Pre-Cut"
  },
  {
    "appended_CSI_Division": [
      "LUMBER"
    ],
    "Unit": "EA",
    "Quantity": 32,
    "Size/Measurement": "2 x 6",
    "Material": "Lumber Pre-Cut"
  },
  {
    "appended_CSI_Division": [
      "LUMBER"
    ],
    "Unit": "EA",
    "Quantity": 17,
    "Size/Measurement": "2 x 4",
    "Material": "Lumber P.T."
  },
  {
    "appended_CSI_Division": [
      "LUMBER"
    ],
    "Unit": "EA",
    "Quantity": 1,
    "Size/Measurement": "2 x 6",
    "Material": "Lumber P.T."
  },
  {
    "appended_CSI_Division": [
      "LUMBER"
    ],
    "Unit": "EA",
    "Quantity": 35,
    "Size/Measurement": "2 x 6",
    "Material": "Lumber P.T."
  },
  {
    "appended_CSI_Division": [
      "LUMBER",
      "LUMBER"
    ],
    "Unit": "EA",
    "Quantity": 6,
    "Size/Measurement": "2 x 8",
    "Material": "Lumber P.T."
  },
  {
    "appended_CSI_Division": [
      "LUMBER"
    ],
    "Unit": "EA",
    "Quantity": 32,
    "Size/Measurement": "3'-3 x 10",
    "Material": "Lumber P.T."
  },
  {
    "appended_CSI_Division": [
      "LUMBER"
    ],
    "Unit": "EA",
    "Quantity": 34,
    "Size/Measurement": "3'-3 x 7 3/4",
    "Material": "Lumber P.T."
  },
  {
    "appended_CSI_Division": [
      "LUMBER",
      "LUMBER"
    ],
    "Unit": "EA",
    "Quantity": 17,
    "Size/Measurement": "2 x 4",
    "Material": "Lumber"
  },
  {
    "appended_CSI_Division": [
      "LUMBER"
    ],
    "Unit": "EA",
    "Quantity": 96,
    "Size/Measurement": "2 x 4",
    "Material": "Lumber"
  },
  {
    "appended_CSI_Division": [
      "LUMBER"
    ],
    "Unit": "EA",
    "Quantity": 5,
    "Size/Measurement": "2 x 6",
    "Material": "Lumber"
  },
  {
    "appended_CSI_Division": [
      "LUMBER"
    ],
    "Unit": "EA",
    "Quantity": 9,
    "Size/Measurement": "2 x 12",
    "Material": "Lumber"
  },
  {
    "appended_CSI_Division": [
      "LUMBER"
    ],
    "Unit": "EA",
    "Quantity": 24,
    "Size/Measurement": "(2) 2 x 8",
    "Material": "Lumber"
  },
  {
    "appended_CSI_Division": [
      "LUMBER"
    ],
    "Unit": "EA",
    "Quantity": 33,
    "Size/Measurement": "2 x 8",
    "Material": "Lumber"
  },
  {
    "appended_CSI_Division": [
      "LUMBER"
    ],
    "Unit": "EA",
    "Quantity": 16,
    "Size/Measurement": "16 FT Length",
    "Material": "Lumber 24\" Deep LSL"
  },
  {
    "appended_CSI_Division": [
      "LUMBER"
    ],
    "Unit": "EA",
    "Quantity": 4,
    "Size/Measurement": "4 FT Length",
    "Material": "24\" Deep Pre-Engineered Floor Trusses"
  },
  {
    "appended_CSI_Division": [
      "LUMBER"
    ],
    "Unit": "EA",
    "Quantity": 4,
    "Size/Measurement": "12 FT Length",
    "Material": "24\" Deep Pre-Engineered Floor Trusses"
  },
  {
    "appended_CSI_Division": [
      "LUMBER"
    ],
    "Unit": "EA",
    "Quantity": 55,
    "Size/Measurement": "30 FT Length",
    "Material": "24\" Deep Pre-Engineered Floor Trusses"
  },
  {
    "appended_CSI_Division": [
      "LUMBER"
    ],
    "Unit": "EA",
    "Quantity": 30,
    "Size/Measurement": "36 FT Length",
    "Material": "Pre-Engineered Roof Trusses"
  },
  {
    "appended_CSI_Division": [
      "LUMBER"
    ],
    "Unit": "EA",
    "Quantity": 12,
    "Size/Measurement": "40 FT Length",
    "Material": "Pre-Engineered Roof Trusses"
  },
  {
    "appended_CSI_Division": [
      "LUMBER"
    ],
    "Unit": "EA",
    "Quantity": 70,
    "Size/Measurement": "3/4\"x4' x 8'",
    "Material": "3/4\" PT Sub-Floor Plywood Floor Sheathing"
  },
  {
    "appended_CSI_Division": [
      "LUMBER"
    ],
    "Unit": "EA",
    "Quantity": 100,
    "Size/Measurement": "3/4\"x4' x 8'",
    "Material": "3/4\" PT CDX Plywood Roof Sheathing"
  },
  {
    "appended_CSI_Division": [
      "LUMBER"
    ],
    "Unit": "SQFT",
    "Quantity": 94,
    "Size/Measurement": "",
    "Material": "Composite Balcony Floor Decking"
  },
  {
    "appended_CSI_Division": [
      "LUMBER"
    ],
    "Unit": "FT",
    "Quantity": 74,
    "Size/Measurement": "",
    "Material": "36\" High Stair Guardrail"
  },
  {
    "appended_CSI_Division": [
      "LUMBER"
    ],
    "Unit": "FT",
    "Quantity": 38,
    "Size/Measurement": "",
    "Material": "42\" High Balcony Guardrail"
  },
  {
    "appended_CSI_Division": [
      "THERMAL & MOISTURE PROTECTION"
    ],
    "Unit": "BUNDLE",
    "Quantity": 33.26,
    "Size/Measurement": "100 SQ.FT. / Bundle, 25 Yr",
    "Material": "Asphalt Shingle"
  },
  {
    "appended_CSI_Division": [
      "THERMAL & MOISTURE PROTECTION"
    ],
    "Unit": "Roll(s)",
    "Quantity": 8.32,
    "Size/Measurement": "400 SQ FT / Roll, 15#",
    "Material": "Asphalt Felt"
  },
  {
    "appended_CSI_Division": [
      "THERMAL & MOISTURE PROTECTION"
    ],
    "Unit": "EA",
    "Quantity": 5.93,
    "Size/Measurement": "10' Lengths",
    "Material": "Ridge Flashing"
  },
  {
    "appended_CSI_Division": [
      "THERMAL & MOISTURE PROTECTION"
    ],
    "Unit": "Bundles",
    "Quantity": 1.8,
    "Size/Measurement": "",
    "Material": "Ridge Shingles"
  },
  {
    "appended_CSI_Division": [
      "THERMAL & MOISTURE PROTECTION"
    ],
    "Unit": "Roll(s)",
    "Quantity": 6.67,
    "Size/Measurement": "3' X 75'",
    "Material": "Ice and Water Shield"
  },
  {
    "appended_CSI_Division": [
      "THERMAL & MOISTURE PROTECTION"
    ],
    "Unit": "EA",
    "Quantity": 5.93,
    "Size/Measurement": "10' Lengths",
    "Material": "Ridge Vent"
  },
  {
    "appended_CSI_Division": [
      "THERMAL & MOISTURE PROTECTION"
    ],
    "Unit": "EA",
    "Quantity": 3.72,
    "Size/Measurement": "12 Widths, 10' Lengths",
    "Material": "Valley Flashing"
  },
  {
    "appended_CSI_Division": [
      "THERMAL & MOISTURE PROTECTION"
    ],
    "Unit": "EA",
    "Quantity": 14.07,
    "Size/Measurement": "12 Widths, 10' Lengths",
    "Material": "Hip Flashing"
  },
  {
    "appended_CSI_Division": [
      "THERMAL & MOISTURE PROTECTION"
    ],
    "Unit": "Bundles",
    "Quantity": 4.26,
    "Size/Measurement": "",
    "Material": "Hip Shingles"
  },
  {
    "appended_CSI_Division": [
      "THERMAL & MOISTURE PROTECTION"
    ],
    "Unit": "BNDLS",
    "Quantity": 2.63,
    "Size/Measurement": "",
    "Material": "Starter Shingles"
  },
  {
    "appended_CSI_Division": [
      "THERMAL & MOISTURE PROTECTION"
    ],
    "Unit": "EA",
    "Quantity": 16.42,
    "Size/Measurement": "1X6, 16' Length",
    "Material": "Fascia Board"
  },
  {
    "appended_CSI_Division": [
      "THERMAL & MOISTURE PROTECTION"
    ],
    "Unit": "EA",
    "Quantity": 26.27,
    "Size/Measurement": "2.5 X 1.5",
    "Material": "Metal Drip Edge"
  },
  {
    "appended_CSI_Division": [
      "THERMAL & MOISTURE PROTECTION"
    ],
    "Unit": "EA",
    "Quantity": 88,
    "Size/Measurement": "spaced at 3' o.c.",
    "Material": "Gutter Hanger"
  },
  {
    "appended_CSI_Division": [
      "THERMAL & MOISTURE PROTECTION"
    ],
    "Unit": "EA",
    "Quantity": 26.27,
    "Size/Measurement": "spaced at 3' o.c.",
    "Material": "Gutter"
  },
  {
    "appended_CSI_Division": [
      "THERMAL & MOISTURE PROTECTION"
    ],
    "Unit": "EA",
    "Quantity": 58.86,
    "Size/Measurement": "1' x 12'",
    "Material": "Ceiling  Soffit"
  },
  {
    "appended_CSI_Division": [
      "THERMAL & MOISTURE PROTECTION"
    ],
    "Unit": "FT",
    "Quantity": 45.53,
    "Size/Measurement": "1' x 12', 12' 6'' Lengths",
    "Material": "F-Channel"
  },
  {
    "appended_CSI_Division": [
      "THERMAL & MOISTURE PROTECTION"
    ],
    "Unit": "EA",
    "Quantity": 12,
    "Size/Measurement": "(None)",
    "Material": "Roof Drain"
  },
  {
    "appended_CSI_Division": [
      "THERMAL & MOISTURE PROTECTION"
    ],
    "Unit": "EA",
    "Quantity": 12,
    "Size/Measurement": "(None)",
    "Material": "Clamping Ring and strainer"
  },
  {
    "appended_CSI_Division": [
      "THERMAL & MOISTURE PROTECTION"
    ],
    "Unit": "EA",
    "Quantity": 12,
    "Size/Measurement": "(None)",
    "Material": "Water Block Flashing"
  },
  {
    "appended_CSI_Division": [
      "THERMAL & MOISTURE PROTECTION"
    ],
    "Unit": "EA",
    "Quantity": 353,
    "Size/Measurement": "4' X10' Sheets",
    "Material": "Board"
  },
  {
    "appended_CSI_Division": [
      "THERMAL & MOISTURE PROTECTION"
    ],
    "Unit": "FT",
    "Quantity": 2615.67,
    "Size/Measurement": "2 Batten",
    "Material": "Batten"
  },
  {
    "appended_CSI_Division": [
      "THERMAL & MOISTURE PROTECTION"
    ],
    "Unit": "Rolls",
    "Quantity": 2.71,
    "Size/Measurement": "9' X 150' Rolls",
    "Material": "Moisture Barrier"
  },
  {
    "appended_CSI_Division": [
      "THERMAL & MOISTURE PROTECTION"
    ],
    "Unit": "EA",
    "Quantity": 254,
    "Size/Measurement": "10' Length",
    "Material": "Metal Furring"
  },
  {
    "appended_CSI_Division": [
      "THERMAL & MOISTURE PROTECTION"
    ],
    "Unit": "EA",
    "Quantity": 22.74,
    "Size/Measurement": "10' Length (Assumed)",
    "Material": "Flashing"
  },
  {
    "appended_CSI_Division": [
      "THERMAL & MOISTURE PROTECTION"
    ],
    "Unit": "Roll(s)",
    "Quantity": 11.69,
    "Size/Measurement": "50' Rolls",
    "Material": "Flashing Tape"
  },
  {
    "appended_CSI_Division": [
      "THERMAL & MOISTURE PROTECTION"
    ],
    "Unit": "EA",
    "Quantity": 15.65,
    "Size/Measurement": "10' Length (Assumed)",
    "Material": "Drip Edge Flashing"
  },
  {
    "appended_CSI_Division": [
      "THERMAL & MOISTURE PROTECTION"
    ],
    "Unit": "EA",
    "Quantity": 20.93,
    "Size/Measurement": "10' Length",
    "Material": "Flashing (Weep Screed)"
  },
  {
    "appended_CSI_Division": [
      "THERMAL & MOISTURE PROTECTION"
    ],
    "Unit": "EA",
    "Quantity": 9,
    "Size/Measurement": "50 sq.ft /Roll",
    "Material": "Insulation"
  },
  {
    "appended_CSI_Division": [
      "THERMAL & MOISTURE PROTECTION"
    ],
    "Unit": "EA",
    "Quantity": 80,
    "Size/Measurement": "50 sq.ft /Roll",
    "Material": "Insulation"
  },
  {
    "appended_CSI_Division": [
      "THERMAL & MOISTURE PROTECTION"
    ],
    "Unit": "EA",
    "Quantity": 66,
    "Size/Measurement": "50 sq.ft /Roll",
    "Material": "Insulation"
  },
  {
    "appended_CSI_Division": [
      "THERMAL & MOISTURE PROTECTION"
    ],
    "Unit": "SQ FT",
    "Quantity": 3215.98,
    "Size/Measurement": "50 sq.ft /Roll",
    "Material": "Insulation"
  },
  {
    "appended_CSI_Division": [
      "THERMAL & MOISTURE PROTECTION"
    ],
    "Unit": "Roll(s)",
    "Quantity": 45.89,
    "Size/Measurement": "50 sq.ft /Roll",
    "Material": "Insulation"
  },
  {
    "appended_CSI_Division": [
      "FINISHES"
    ],
    "Unit": "EA",
    "Quantity": 54,
    "Size/Measurement": "1/2'' THK , 4' x 10' Sheets",
    "Material": "MR (Green Board) Gypsum Wall Board"
  },
  {
    "appended_CSI_Division": [
      "FINISHES"
    ],
    "Unit": "EA",
    "Quantity": 70,
    "Size/Measurement": "5/8 , 4' x 10' Sheets",
    "Material": "MR (Green Board) Gypsum Wall Board"
  },
  {
    "appended_CSI_Division": [
      "FINISHES"
    ],
    "Unit": "EA",
    "Quantity": 28,
    "Size/Measurement": "5/8'' THK,  4' x 10' Sheets",
    "Material": "Type X Gypsum Wall Board"
  },
  {
    "appended_CSI_Division": [
      "FINISHES"
    ],
    "Unit": "EA",
    "Quantity": 388,
    "Size/Measurement": "1/2'' THK,  4' x 10' Sheets",
    "Material": "Regular Gypsum Wall Board"
  },
  {
    "appended_CSI_Division": [
      "FINISHES"
    ],
    "Unit": "EA",
    "Quantity": 36,
    "Size/Measurement": "1/2'' THK, 4' x 8' Sheets",
    "Material": "Tile backer board"
  },
  {
    "appended_CSI_Division": [
      "FINISHES"
    ],
    "Unit": "EA",
    "Quantity": 24.44,
    "Size/Measurement": "250' Roll",
    "Material": "Joint Tape"
  },
  {
    "appended_CSI_Division": [
      "FINISHES"
    ],
    "Unit": "EA",
    "Quantity": 25.84,
    "Size/Measurement": "4.5 Gal Joint Compound",
    "Material": "Joint Compound"
  },
  {
    "appended_CSI_Division": [
      "FINISHES"
    ],
    "Unit": "EA",
    "Quantity": 1.4,
    "Size/Measurement": "250' Roll",
    "Material": "Fire Tape"
  },
  {
    "appended_CSI_Division": [
      "FINISHES"
    ],
    "Unit": "Box(s)",
    "Quantity": 7.96,
    "Size/Measurement": "#8 2 Screws Box Size: 5000 Qty",
    "Material": "Drywall Screws"
  },
  {
    "appended_CSI_Division": [
      "FINISHES"
    ],
    "Unit": "FT",
    "Quantity": 3254,
    "Size/Measurement": "1-5/8 16'' O.C",
    "Material": "Light Gage Galvanized Furring Channel"
  },
  {
    "appended_CSI_Division": [
      "FINISHES"
    ],
    "Unit": "EA",
    "Quantity": 181.2,
    "Size/Measurement": "10' Lengths",
    "Material": "Inside Bead"
  },
  {
    "appended_CSI_Division": [
      "FINISHES"
    ],
    "Unit": "EA",
    "Quantity": 26.8,
    "Size/Measurement": "10' Lengths",
    "Material": "Outside Bead"
  },
  {
    "appended_CSI_Division": [
      "FINISHES"
    ],
    "Unit": "EA",
    "Quantity": 194.62,
    "Size/Measurement": "10' Lenghts",
    "Material": "J-Beads"
  }
]
```

I also wonder why the output isn’t according to the order of items in “Fields to split by”

Screenshot 2026-01-08 164935
Screenshot 2026-01-08 1649352674×1284 441 KB

4

Thank you @Elliemenopi, this really helps,

I can see that the two missing items are simply duplicated items (so the quotes inside quotes wasn’t the case):

image
image955×359 46.9 KB

Here’s how you can identify this using a Code node (use AI), and then remove them using a Remove Duplicates node:

I found that if I write them in reverse order, they appear correctly:

Unit, Quantity, Size/Measurement, Material

Hope everything is okay now..

5

I tried this and it fixed it! thank you! :grinning_face_with_smiling_eyes:

1 Like