Create 2 arrays from 1. One array with Unique Items, and the second with occurrence of those items

Hi @Joshua Mursic! Would you please include a screenshot of a sample of the original array? Or confirm that I’m understanding it correctly with the example below?

var origList = ["item 1", "item 1", "item 1", "item 1", "item 1", "item 1", "item 1", "item 2", "item 2", "item 3", "item 3", "item 3", "item 3"];

Where the desired output would be:

itemList = [item 1, item 2, item 3];

qtys = [7, 2, 4];

@Joshua Mursic Awesome! This should do it for you :)

const arr = ["item 1", "item 1", "item 1", "item 1", "item 1", "item 1", "item 1", "item 2", "item 2", "item 3", "item 3", "item 3", "item 3"]; // Obviously, replace this with the actual array from your inputData

const items = [];
const qtys = [];

for (var i = 0; i < arr.length; i++) {
  if (items.includes(arr[i])) {
    qtys[items.indexOf(arr[i])] += 1;
  } else {
    items.push(arr[i]);
    qtys.push(1);
  }
}

output = [{items, qtys}];

And this is what the result looks like when placing it into a QBO create invoice step: