question

sara S2 avatar image
0 Likes"
sara S2 asked sara S2 commented

The subtraction of 'array' type values.

Hello,

I have two columns of array data type in a global table. How to write the subtraction value of those columns values in the third column?

Regards.

Other
Other (please specify)
substractionarray type data
· 2
5 |100000

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

1 Answer

Phil BoBo avatar image
1 Like"
Phil BoBo answered sara S2 commented
  1. Table table = Table("GlobalTable1");
  2. Array array1 = table[1][1];
  3. Array array2 = table[1][2];
  4. Array difference = [array1[1]-array2[1], array1[2]-array2[2], array1[3]-array2[3]];
  5. table[1][3] = difference;


1589482695698.png (85.1 KiB)
· 2
5 |100000

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.