市町村コード作成 - 経済統計練習帳

var city=new Array();
var sta=new Array();
 
function myFunction() {
 
 id="1mV2dvW_EKRaRXvpCK61WGtYku4_gcVnneyRFoXE5";
 
var sql = "SELECT city from " +id;
sql=sql+" where code_line=78"; 
 
  var result = FusionTables.Query.sqlGet(sql);
 
 var r=result.rows;
 
sx=0;
for(i in r){
sx=sx+1;
city[sx]=r[i][0];
}
 
number=sx;  
 
 dicnumber=0;
 
  var dic=new Array();
 
  for(s=1;s<number+1;s++){
    h=0;
    for(sx=1;sx<dicnumber+1;sx++){
  if(city[s]==dic[sx])h=100;
    }
  if(h<50)dicnumber=dicnumber+1;
  if(h<50)dic[dicnumber]=city[s];  
  }  
 
Logger.log(dicnumber);
 
 
var id2="1cizC1u7bdNLUdNfyMpDoMFg-4bB6LC6Kfy5wAjdMd7A"; 
ex2 = SpreadsheetApp.openById(id2);
 
  var sh2 = ex2.getSheetByName("data");
 
  var dicx=new Array();
 
  for(sx=0;sx<dicnumber+1;sx++){
  dicx[sx]=new Array();
  }
 
 
   for(sx=1;sx<dicnumber+1;sx++){
    dicx[sx][0]=dic[sx];  
    }
 
 
  dicx[0][0]="市町村コード";
 
sh2.getRange(1,1,dicnumber+1,1).setValues(dicx);
 
 
 
 
 
 
 
}