warauu - 経済統計練習帳

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;
 
function g(){
 
 
  sql("1BCXvu_E0VeIFM_WN-SHx5zlLzzMr8Kgc8Qsi1weV");
 
  Logger.log(number);
 
 
 
 
 
 
 
}
 
 
function sql(idx,nx,cx) {
 
  var sql = 'SELECT artist,code 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][0];
    codex[sx]=""+r[i][1];
  if(codex[sx].indexOf("N")>-1)codex[sx]="";
    }
 
  number=sx;
 
 
}