|
其实多表的合并,建议楼主可在明细表里加一列月份,然后用Power Query追加合并,感觉那个比SQL好控制格式,下图就是用Power Query合并的,方便快捷无代码,也不需要纠结你可能有状况的源数据。
感觉不是13个明细表里有数据的部分有状况,是无数据的部分出现了无法预知的东西,导致某些列被识别为文本。如果执意要用SQL,下面是我的结论:
- SELECT "期初数" AS "月份",* FROM [期初数$] UNION ALL
- SELECT "1月销售",* FROM [1月销售$] UNION ALL
- SELECT "2月销售",* FROM [2月销售$] UNION ALL
- SELECT "3月销售",* FROM [3月销售$] UNION ALL
- SELECT "4月销售",* FROM [4月销售$] UNION ALL
- SELECT "5月销售",* FROM [5月销售$] UNION ALL
- SELECT "6月销售",* FROM [6月销售$] UNION ALL
- SELECT "7月销售",* FROM [7月销售$] UNION ALL
- SELECT "8月销售",* FROM [8月销售$] UNION ALL
- SELECT "9月销售",* FROM [9月销售$] UNION ALL
- SELECT "10月销售",* FROM [10月销售$] UNION ALL
- SELECT "11月销售",* FROM [11月销售$] UNION ALL
- SELECT "12月销售",* FROM [12月销售$]
复制代码 这样不加定义表格范围不行
- SELECT "期初数" AS "月份",* FROM [期初数$] UNION ALL
- SELECT "1月销售",* FROM [1月销售$A1:Y4] UNION ALL
- SELECT "2月销售",* FROM [2月销售$A1:Y4] UNION ALL
- SELECT "3月销售",* FROM [3月销售$A1:Y4] UNION ALL
- SELECT "4月销售",* FROM [4月销售$A1:Y4] UNION ALL
- SELECT "5月销售",* FROM [5月销售$A1:Y4] UNION ALL
- SELECT "6月销售",* FROM [6月销售$A1:Y4] UNION ALL
- SELECT "7月销售",* FROM [7月销售$A1:Y4] UNION ALL
- SELECT "8月销售",* FROM [8月销售$A1:Y4] UNION ALL
- SELECT "9月销售",* FROM [9月销售$A1:Y4] UNION ALL
- SELECT "10月销售",* FROM [10月销售$A1:Y4] UNION ALL
- SELECT "11月销售",* FROM [11月销售$A1:Y4] UNION ALL
- SELECT "12月销售",* FROM [12月销售$A1:Y4]
复制代码
这样定义了就可以了
我感觉主要问题不在SQL语句上,而是在那13个原始表格上,楼主好好检查原始表格有什么幺蛾子吧。
2020年建材公司应收帐款a.zip
(27.76 KB, 下载次数: 6)
2020年建材公司应收帐款b.zip
(34.89 KB, 下载次数: 5)
|
评分
-
1
查看全部评分
-
|