koukjjj - 経済統計練習帳

var namex=new Array();
var codex=new Array();
var dic_name=new Array();
var dic_code=new Array();
var number;
var dicnumber;
 
function g(){
 
 var id="1qVDxNqTt7hk40D0dBdQRopLbrCgJ7d3xWCLM83ZuVmg";
 
 
 var ex = SpreadsheetApp.openById(id);
  var sheet = ex.getSheetByName("dic");  
 
  dicnumber=sheet.getLastRow()-1;
 
  Logger.log(dicnumber);
 
  var v=sheet.getRange(1,1,dicnumber+1,2).getValues(); 
 
  for(s=1;s<dicnumber+1;s++){
  dic_name[s]=v[s][0];
  dic_code[s]=v[s][1];
   }
 
 
 
 
 
}
 
function plus() {
 
  g();
 
  var id="1qVDxNqTt7hk40D0dBdQRopLbrCgJ7d3xWCLM83ZuVmg";
 
 
 var ex = SpreadsheetApp.openById(id);
  var sheet = ex.getSheetByName("dic");
 
 
idx="1yu_RNwcRbEbPdG_1Kk4h7FOMK57uiy0HA75JBlAG";
nx=4;
cx=5;  
 
sql(idx,nx,cx);
 
  for(s=1;s<number+1;s++){
  h=0;  
  for(sx=1;sx<dicnumber+1;sx++){
  if(namex[s]==dic_name[sx])h=100;
  }
  if(codex[s].length<2)h=100;
  if(h<60)dicnumber=dicnumber+1;
  if(h<60)dic_name[dicnumber]=namex[s];
  if(h<60)dic_code[dicnumber]=codex[s];
  }
 
Logger.log(dicnumber);  
 
  var vs=new Array();
 
  for(s=0;s<dicnumber+1;s++){
  vs[s]=new Array();
  }
 
  vs[0][0]="name";
  vs[0][1]="code";
 
   for(s=1;s<dicnumber+1;s++){
  vs[s][0]=dic_name[s];
  vs[s][1]=dic_code[s];
   }
 
sheet.getRange(1,1,dicnumber+1,2).setValues(vs);  
 
 
}
 
function sql(idx,nx,cx) {
 
  var sql = 'SELECT * FROM ' +idx;
 
  var result = FusionTables.Query.sqlGet(sql, {hdrs: false});
 
 var r=result.rows;
 
  sx=0;
    for(var i in r){
    sx=sx+1;
    namex[sx]=r[i][nx];
    codex[sx]=""+r[i][cx];
  if(codex[sx].indexOf("N")>-1)codex[sx]="";
    }
 
  number=sx;
 
 
}