スタッフ - 経済統計練習帳

var idx=new Array();
var namex=new Array();
var codex=new Array();
var title=new Array();
 
function myFunction() {
 
  id="1dL9qaxgJ8-_5bF99k4-5AW2FTQzr2myttSyiVWP7";
 
var sql = 'SELECT * FROM ' +id;
 sql=sql+" where credit='Ｐ'"
  var result = FusionTables.Query.sqlGet(sql);
 
 var r=result.rows;
 
sx=0;
for(i in r){
sx=sx+1;
namex[sx]=r[i][2];
codex[sx]=r[i][1];
}
 
number=sx;
 
 
Logger.log(number);
 
 id="1mP7sXTO9wnsJo-eejPGeKCiFkw7_QsNoFfgnAGmz";
 
 sql = 'SELECT * FROM ' +id;
 
 result = FusionTables.Query.sqlGet(sql);
 
 r1=result.rows;
 
sx=0;
for(i in r1){
sx=sx+1;
title[sx]=r1[i][2];
}
 
   var v=new Array();
  for(s=0;s<number+1;s++){
  v[s]=new Array();
  }
 
 
 
 v[0][1]="p";
for(s=1;s<number+1;s++){
  sx=codex[s];
  v[s][0]=title[sx];
  v[s][1]=namex[s];
}
 
 
 var id="172muqeTgbqQ6khNw5wSIqjzoPYdoTQ2rli_4bP85QHM";
  var ex = SpreadsheetApp.openById(id);
 var sheet = ex.getSheetByName("data");  
 
 
sheet.getRange(1,1,number+1,2).setValues(v);
 
 
 
}