jyanijj - 経済統計練習帳

var namex=new Array();
var codex=new Array();
var dic_name=new Array();
var dic_code=new Array();
var dic_key=new Array();
var number;
var dicnumber;
 
var year=new Array();
var t=new Array();
var rate=new Array();
 
function myFunction() {
 
sql_tv("1mP7sXTO9wnsJo-eejPGeKCiFkw7_QsNoFfgnAGmz");  
 
 
 
 
 
sql("1Za6b1nBoE8UJEYeFjG5D62LV6-w-5atQTnc3ode2",1,3);  
 
  var point=new Array();
 
sx=0;
  for(s=1;s<number+1;s++){
  if(codex[s]=="235100")sx=sx+1;
   if(codex[s]=="235100")point[sx]=namex[s];  
  }
 
  number_point=sx;
 
  for(s=1;s<number_point+1;s++){ 
  sx=point[s];
  }
 
  id3="1LjLhA1VOcFhLUHCluAbkzlLzHRMYg2nnzv86U7n767c";
 
  var ex3 = SpreadsheetApp.openById(id3);
  var sh3 = ex3.getSheetByName("data");
 
  var v3=new Array();
  for(s=0;s<number_point+1;s++){
  v3[s]=new Array();
  }
  v3[0][2]="rate";
  for(s=1;s<number_point+1;s++){
  sx=point[s];
  v3[s][0]=year[sx];
  v3[s][1]=t[sx];
  v3[s][2]=rate[sx];
  }
 
 
  sh3.getRange(1,1,number_point+1,3).setValues(v3);
 
 
 
 
 
 
 
}
 
 
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;
 
 
}
function sql_tv(idx) {
 
  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;
    t[sx]=r[i][2];
    year[sx]=""+r[i][0];
    rate[sx]=""+r[i][5]; 
    }
 
  number=sx;
 
 
}