Comparing Two Items between Two Arrays

Question

Comparing Two Items between Two Arrays

I have a scenario where I need to compare values in two arrays by running a condition. The data is pulled from a spreadsheet, and if the condition is met, I want to copy the respective data.

For instance, I aim to compare two cells within a spreadsheet - copying the higher value from one cell and updating the lower value in the second cell. Being new to coding, I would appreciate any advice or guidance on how to approach this.

function copyRANGEHIGH() { 
  var NEWHIGH = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("INDEX-RANGE");
  var OLDHIGH = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("INDEX-RANGE");  

  var VALNEWHIGH1 = NEWHIGH.getRange("U4").getValues(); //DIA
  var VALOLDHIGH1 = OLDHIGH.getRange("P5").getValues(); 

  var VALNEWHIGH2 = NEWHIGH.getRange("U22").getValues();//SPY
  var VALOLDHIGH2 = OLDHIGH.getRange("P23").getValues();

  var VALNEWHIGH3 = NEWHIGH.getRange("U39").getValues();//IWM
  var VALOLDHIGH3 = OLDHIGH.getRange("P40").getValues();

  var arr1=[VALNEWHIGH1,VALNEWHIGH2,VALNEWHIGH3];
  var arr2=[VALOLDHIGH1,VALOLDHIGH2,VALOLDHIGH3];


  for (var i=0; i < arr1.length; i++) {
  for (var j=0; j < arr2.length; j++) {
  //  Browser.msgBox(arr1[i])
     if ( arr1[i] > arr2[j] ) {

javascript arrays google-apps-script

Answer 1

Answer №1

Your code suggestion tackles the comparison of two arrays by looping over them and checking if one element is greater than another. Here's an alternative approach:

const newArr=[VALNEW1, VALNEW2, VALNEW3];
const oldArr=[VALOLD1, VALOLD2, VALOLD3];

//By utilizing a single loop that iterates through both arrays simultaneously,
//you can compare corresponding elements efficiently.

for (let i = 0; i < newArr.length; i++) {  
   if (parseFloat(newArr[i]) > parseFloat(oldArr[i])) {
       //Value in newArr is greater
       //Additional actions can be executed here.
   }
}

To enhance the code further and ensure safe numeric conversion, you may consider incorporating additional precautions for unexpected non-numeric values. However, the provided code should offer a solid starting point for your implementation.

Answer 2

Your code suggestion tackles the comparison of two arrays by looping over them and checking if one element is greater than another. Here's an alternative approach:

const newArr=[VALNEW1, VALNEW2, VALNEW3];
const oldArr=[VALOLD1, VALOLD2, VALOLD3];

//By utilizing a single loop that iterates through both arrays simultaneously,
//you can compare corresponding elements efficiently.

for (let i = 0; i < newArr.length; i++) {  
   if (parseFloat(newArr[i]) > parseFloat(oldArr[i])) {
       //Value in newArr is greater
       //Additional actions can be executed here.
   }
}

To enhance the code further and ensure safe numeric conversion, you may consider incorporating additional precautions for unexpected non-numeric values. However, the provided code should offer a solid starting point for your implementation.

Comparing Two Items between Two Arrays

Answer №1

Similar questions

Issue with loading the main.css file

Regular occurrences of heap memory exhaustion within a node.js application running in a docker container

Classify JavaScript Array Elements based on their Value

Automatically formatting text upon entering it in Vue.js

When using NextJS with Redux Persist, the HTML does not get rendered in the initial server

Tips for adding styling to HTML in Vue by entering CSS code into the CodeMirror editor

Creating visual representations of class, organization, flow, or state diagrams using Vega or Vega-lite

Tips on allowing a rectangle to be draggable using HTML5

Creating indexes for a two-dimensional NumPy array

Executing a personalized function - settings.func does not exist as a valid function

The Journey of React Components: How Child Components Embrace the State Props of the Past

How can I update two divs simultaneously with just one ajax call?

Allocating arrays on the heap: choosing between separate allocation and contiguous allocation?

Javascript Leap Year Determination using nested if-else statements

The distinction between a keypress event and a click event

Tips for parsing a JSON file within my node.js application?

When using the v-for directive to display all elements of an array, only the information of the clicked array should be listed when using the

Navigating URLs with Ajax Requests in CakePHP

The accumulation of input using setInterval is not effective

Transcribing live content directly from the browser tab