jquery 处理json数据问题！急！在线等！

Question

var json={"Table1":[{"XMID":"B0","ysdate":"2015-01-01T00:00:00","SZH":7373.0},{"XMID":"B0","ysdate":"2015-01-02T00:00:00","SZH":7845.0},{"XMID":"C0","ysdate":"2015-01-01T00:00:00","SZH":327.0},{"XMID":"C0","ysdate":"2015-01-02T00:00:00","SZH":295.0},{"XMID":"D","ysdate":"2015-01-01T00:00:00","SZH":211.0},{"XMID":"D","ysdate":"2015-01-02T00:00:00","SZH":254.0},{"XMID":"K","ysdate":"2015-01-01T00:00:00","SZH":7911.0},{"XMID":"K","ysdate":"2015-01-02T00:00:00","SZH":8394.0}]}

最终想要js输出表格：
ysdate B0 C0 D K
2015-01-01 7373.0 327.0 211.0 7911.0
2015-01-02 7845.0 295.0 254.0 9394.0

Answer 1

http://ask.csdn.net/questions/161313

发了2个贴？发个自动标题的给你，更新了下代码

    var json = { "Table1": [
    { "XMID": "B0", "ysdate": "2015-01-01T00:00:00", "SZH": 7373.0 },
    { "XMID": "B0", "ysdate": "2015-01-02T00:00:00", "SZH": 7845.0 },
    { "XMID": "C0", "ysdate": "2015-01-01T00:00:00", "SZH": 327.0 },
    { "XMID": "C0", "ysdate": "2015-01-02T00:00:00", "SZH": 295.0 },
    { "XMID": "D", "ysdate": "2015-01-01T00:00:00", "SZH": 211.0 },
    { "XMID": "D", "ysdate": "2015-01-02T00:00:00", "SZH": 254.0 },
    { "XMID": "K", "ysdate": "2015-01-01T00:00:00", "SZH": 7911.0 },
    { "XMID": "K", "ysdate": "2015-01-02T00:00:00", "SZH": 8394.0}]
    };
    var rows = json.Table1,item;
    var result = {},ritem,keys=',',key;
    for (var i = 0, j = rows.length; i < j; i++) {
        item = rows[i];
        ritem = result[item.ysdate] || {};
        key = item.XMID;
        if (keys.indexOf(',' + key + ',') == -1) keys += key + ',';
        if (ritem[key]) ritem[key] += ',' + item.SZH;
        else ritem[key] = item.SZH;
        result[item.ysdate] = ritem;
    }
    var s = '<table border="1"><tr><th>ysdate</th>';
    var arr = keys.replace(/^,|,$/g,'').split(',');
    for (var i = 0; i < arr.length; i++) s += '<th>'+arr[i]+'</th>';
    s += '</tr>';
    for (k in result) {
        s += '<tr><td>' + (k.split('T')[0]) + '</td>'
        for (var i = 0; i < arr.length; i++) s += '<td>' + (result[k][arr[i]] || '') + '</td>';
    }
    s += '</table>';
    document.write(s);