How to group 3 values ​​into one?

I did not change anything. Redid the request in another way. It turns out arrays are much more labor-intensive than objects. Therefore, the decision was made as follows. Abandon google fusion table, and for starters, make a lookout on the following script

1. To make object from the clients table
2. Make a lookup object for each customer's products.
3. Go through the clients.producst and clients.thresholds tables, write data to the clients / products lookups by keys
4. Build clients / products back into arrays

1 pass on each table in the amount of - 3 table views (since there are only 3 tables)

Result. I processed more than 6 minutes in the previous version, now it is less than 7 seconds Plus, I think there is something else that needs to be optimized.

 var ss = SpreadsheetApp.openById(SHEET_ID); 
 var ss = SpreadsheetApp.openById(SHEET_ID); 
  // values
   var stor = {
     clients: ss.getSheetByName ("clients"). getDataRange (). getValues ​​(). slice (1),
     products: ss.getSheetByName ("clientsProducts"). getDataRange (). getValues ​​(). slice (1),
     percents: ss.getSheetByName ("clientsProductsPercents"). getDataRange (). getValues ​​(). slice (1)
   } 

  // indexes
   var i = {
     clients: clientsIndex (SHEET_ID, "clients"),
     products: clientsProductsIndex (SHEET_ID, "clientsProducts"),
     percents: clientsProductsPercentsIndex (SHEET_ID, "clientsProductsPercents"),
   } 

  function mapClient (client) {
     var key = client [i.clients.key];
     return {
                 key: key,
                 name: client [i.clients.name],
                 },
                 percent: {
                     reward: client [i.clients.percent.reward],
                     tariff: client [i.clients.percent.tariff]
                 },
                 products: {}
             }
     } 

  function reduceClient (clients, client) {
      clients [client.key] = client;
     return clients
   } 

  var clients = Enumerable.From (stor.clients) .Select (mapClient) .ToArray (). reduce (reduceClient, {}); 

  function mapClientProducts (row) {
     var client = row [i.products.key] .split ("-") [0];
     var product = row [i.products.key] .split ("-") [1];
     clients [client] .products [product] = {
         limit: {
             max: row [i.products.limit.max],
             min: row [i.products.limit.min]
         },
         percents: {}
         product: product
     };
   } 

  Enumerable.From (stor.products) .Select (mapClientsProducts) .Count (); 

  function mapClientsProductsPercents (row) {
     var product = row [i.percents.key] .split ("-") [1];
     var client = row [i.percents.key] .split ("-") [0];
     clients [client] .products [product] .percents = {
             reward: row [i.percents.percent.reward],
             tariff: row [i.percents.percent.tariff],
             threshold: row [i.percents.percent.threshold]
         }
   } 

  Enumerable.From (stor.percents) .Select (mapClientsProductsPercents) .Count (); 

  function mapProducts (client) {
   var products = Enumerable.From (client.Value.products) .Select ("$. Value"). ToArray ();
   client.Value.products = products;
   return client.Value;
 } 

  var result = Enumerable.From (clients) .Select (mapProducts) .ToArray (); 

  return JSON.stringify (result, null, 4);
 }