天软金融分析.NET函数大全 > TSL函数 > 基础函数 > 数组 > 表格显示

ShowTableByInverse    

简述
数据表t转置，其中KeyField为列名，该列的数据转置后作为列标名，FieldARR为需要显示的字段，ShowNumber表示显示原数据keyfield行(转置后列)的数量。
定义
ShowTableByInverse(t:array;KeyField:String;FieldArr:array;ShowNumber:integer):Array
参数
名称类型说明
tarray数据表类型，数据
KeyFieldString字符串，转置后用作列标的值的列名
FieldArrarray数组，要显示的字段列表，给非数组则显示所有字段。
注意，函数中会删除fieldarr的首行，原因是一般首行代表的列标都是KeyField转置后用作列标的值的列名，使返回结果内容不重复。
ShowNumberinteger整数，显示个数
返回Array数组。
  • 范例

    //生成数据表t
    t:=array(("代码":"SH600006","名称":"东风汽车","主营业务收入":151953.06,"主营业务利润":30559.66,"营业费用":10112.75,"管理费用":10666.36,"财务费用":-894.46,"营业利润":10693.23,"投资收益":-151.01,"利润总额":9904.7,"所得税":2413.81,"净利润":7873.08,"货币资金":-11664.28,"短期投资":-5370.7,"主营业务收入":167855.56,"主营业务利润":31127.95,"营业费用":4452.79,"管理费用":10541.15,"财务费用":-1013.26,"营业利润":17162.48,"投资收益":150.81,"利润总额":17246.26,"所得税":2629.5,"净利润":14574.03,"货币资金":532.5,"短期投资":4962.47),("代码":"SH600007","名称":"中国国贸","主营业务收入":19715.3,"主营业务利润":10383.2,"营业费用":238.4,"管理费用":1422.7,"财务费用":1304.4,"营业利润":7417.7,"投资收益":81.1,"利润总额":6404.6,"所得税":2433.4,"净利润":3971.2,"货币资金":2964.5,"短期投资":0.00,"主营业务收入":17727.7,"主营业务利润":9989.1,"营业费用":165.5,"管理费用":1151.3,"财务费用":-18.2,"营业利润":8690.5,"投资收益":186.2,"利润总额":9208.6,"所得税":2977.1,"净利润":6231.5,"货币资金":-8101.2,"短期投资":0.00));
    return ShowTableByInverse(t,'代码','',2);
    返回:
相关