gkuuu - 経済統計練習帳

var idx=new Array();
var namex=new Array();
var codex=new Array();
 
function myFunction() {
 
  id="1RUzFoM43tzwiLJiDbVMXFv8GricnMNkQc5RIVABW";
 
var sql = 'SELECT ROWID,artist,code FROM ' +id;
 
  var result = FusionTables.Query.sqlGet(sql);
 
 var r=result.rows;
 
sx=0;
for(i in r){
p=""+r[i][2];
if(p.length<1)p="N";
if(p.indexOf("N")>-1)sx=sx+1;
if(p.indexOf("N")>-1)idx[sx]=r[i][0];
if(p.indexOf("N")>-1)namex[sx]=r[i][1];
}
 
number=sx;
 
Logger.log(number);
 
for(tr=1;tr<number+1;tr++){
 
id2="16zlbESM_0PL9DVz7BpKayLwLdAMFTxHFQKoPxbfL";
 
var sql2 = 'SELECT * FROM ' +id2;
sql2=sql2+" where artist='"+namex[tr]+"'";
 
  var result2 = FusionTables.Query.sqlGet(sql2);
 
 var r2=result2.rows;
 
var cc="";
 
for(i in r2){
cc=r2[i][1];
}
 
Logger.log(cc);
 
if(cc.length>0){
 
var upd = "update "+id+" set code = '"+cc+"' where rowid ='"+idx[tr]+"'";
 
FusionTables.Query.sql(upd);
 
}
 
}
 
 
 
 
 
}