datastage通过Pivot Enterprise stage实现行转列
通过datastage实现输入数据如下:REPIDlast_nameJan_salesFeb_salesMar_sales100Smith1234.081456.801578.00101Yamada1245.201765.001934.22输出数据如下:REPIDlast_nameQ1salesPivot_index100Smith1234.080100Smith1456.801100Smith1578.002101Yamada1245.200101Yamada1765.001101Yamada1934.222
下载地址
用户评论