Remove array of arrays from array of arrays google sheets script/ javascript

Question

I am creating a google script to grab multiple rows from multiple sheets put the columns in to and array of arrays and, grab existing and do the same, I then merge both arrays together and delete duplicates:

  var existingItems = getSKUdata()
  var newItems = getPurchasedata()
  var mergedData = existingData
  for (item of newItems) {
    mergedData.push(item)
  }
  const mergedCleaned = Array.from(new Set(mergedData.map(JSON.stringify)), JSON.parse)

then remove any the arrays from 'existingItems' out of 'margedCleaned'. so I can import the newly added items without having any duplicates.

Current arrays:

newItems = [
   ['AAA-AAA','AAAA', '01.00'],
   ['BBB-BBB','BBBB', '02.00'],
   ['CCC-CCC','CCCC', '03.00'],
   ['DDD-DDD','DDDD', '04.00']
];

existingItems = [
   ['AAA-AAA','AAAA', '01.00'],
   ['BBB-BBB','BBBB', '02.00'],
];

I want to 'newItems' to have all the 'existingItems' removed so I can write the new arrays/ rows to my google sheets document.

newItems= [
   ['CCC-CCC','CCCC', '03.00']
   ['DDD-DDD','DDDD', '04.00']
];

I have tried multiple different snippets from other questions but nothing seems to work it doesn't remove the arrays. Only can use core-javascript

I want to try remove the existing data from the array before pushing the data to help speed it up, or wouldn't it make much of a difference speed wise? — BlvckSZN
– BlvckSZN, Commented Sep 5, 2022 at 21:39

TheMaster · Accepted Answer · 2022-09-05 21:50:38Z

1

Use Set and filter using the joint array values as keys:

/*<ignore>*/console.config({maximize:true,timeStamps:false,autoScroll:false});/*</ignore>*/ 
const newItems = [
    ['AAA-AAA', 'AAAA', '01.00'],
    ['BBB-BBB', 'BBBB', '02.00'],
    ['CCC-CCC', 'CCCC', '03.00'],
    ['DDD-DDD', 'DDDD', '04.00'],
  ],
  existingItems = [
    ['AAA-AAA', 'AAAA', '01.00'],
    ['BBB-BBB', 'BBBB', '02.00'],
  ],
  existingItemsSet = new Set(existingItems.map((row) => row.join('⚅'))),
  filteredNewItems = newItems.filter((row) =>
    !existingItemsSet.has(row.join('⚅'))
  );
console.log(filteredNewItems);

<!-- https://meta.stackoverflow.com/a/375985/ -->    <script src="https://gh-canon.github.io/stack-snippet-console/console.min.js"></script>

answered Sep 5, 2022 at 21:50

TheMaster

51.6k7 gold badges76 silver badges102 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

BlvckSZN Over a year ago

Apologies, I forgot to add after I've grabbed existing and new data I'm merging them and deleting duplicates so its just logging a blank array: var mergedData = existingItems for (item of newItem) { mergedData.push(item) } const mergedCleaned = Array.from(new Set(mergedData.map(JSON.stringify)), JSON.parse)

TheMaster Over a year ago

@BlvckSZN So ?

BlvckSZN Over a year ago

When I run your script with it, it returns a blank array. when I remove the part where I remove duplicated items in the array it works fine

TheMaster Over a year ago

@BlvckSZN If you're still having trouble, ask a new question with sample data. Your latest modification to the question is unclear.

Collectives™ on Stack Overflow

Remove array of arrays from array of arrays google sheets script/ javascript

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related