请教各位高手解决几个工作提数生成订单跟进表

yjyidfk

各位老师:

大家好!

我现在有一个订单跟进表,之前我用公式作了一个,从8个工作表中提数到一个最终的汇总表,但是由数据太大,运算太慢,

我现在想用透视表来做,不知哪位老师,可以帮我解决这个问题

penghaifeng

select 订单编号,序号,产品名称,形状,规格,加工要求,出货日期,切割完成,0 as 磨边完成数,0 as 斜边完成数, 0 as 丝印完成数, 0 as 钢化完成数, 0 as 中空完成数,0 as 夹胶完成数,0 as 包装完成数  from [切割$] union all

select 订单编号,序号,产品名称,形状,规格,加工要求,出货日期,0 as 切割完成, 磨边完成数,0 as 斜边完成数, 0 as 丝印完成数, 0 as 钢化完成数, 0 as 中空完成数,0 as 夹胶完成数,0 as 包装完成数  from [磨边$] union all

select 订单编号,序号,产品名称,形状,规格,加工要求,出货日期,0 as 切割完成, 0 as 磨边完成数, 斜边完成数, 0 as 丝印完成数, 0 as 钢化完成数, 0 as 中空完成数,0 as 夹胶完成数,0 as 包装完成数  from [斜边$] union all
select 订单编号,序号,产品名称,形状,规格,加工要求,出货日期,0 as 切割完成, 0 as 磨边完成数, 0 as 斜边完成数, 丝印完成数, 0 as 钢化完成数, 0 as 中空完成数,0 as 夹胶完成数,0 as 包装完成数  from [丝印$] union all
select 订单编号,序号,产品名称,形状,规格,加工要求,出货日期,0 as 切割完成, 0 as 磨边完成数, 0 as 斜边完成数, 0 as 丝印完成数, 钢化完成数, 0 as 中空完成数,0 as 夹胶完成数,0 as 包装完成数  from [钢化$] union all
select 订单编号,序号,产品名称,形状,规格,加工要求,出货日期,0 as 切割完成, 0 as 磨边完成数, 0 as 斜边完成数, 0 as 丝印完成数, 0 as 钢化完成数, 中空完成数,0 as 夹胶完成数,0 as 包装完成数  from [中空$] union all
select 订单编号,序号,产品名称,形状,规格,加工要求,出货日期,0 as 切割完成, 0 as 磨边完成数, 0 as 斜边完成数, 0 as 丝印完成数, 0 as 钢化完成数, 0 as 中空完成数,夹胶完成数,0 as 包装完成数  from [夹胶$] union all
select 订单编号,序号,产品名称,形状,规格,加工要求,出货日期,0 as 切割完成, 0 as 磨边完成数, 0 as 斜边完成数, 0 as 丝印完成数, 0 as 钢化完成数, 0 as 中空完成数,0 as 夹胶完成数,包装完成数  from [包装$]

可参照上述样式构造外部数据查询；不过楼主的数据源格式及名称需要重新做一下统一规范才好！~~~

bolliy

数据规范是数据分析的第一步

yjyidfk

老师,你好,首先感谢帮我解决问题,

我对所有表格的格进行了修改,并编了select语句,但是还是不行,可否帮我检查一下,到底问题出在哪了,

先谢了!

penghaifeng

看来楼主还不够仔细！~~~
给你找了两种错误，如下图红色圆圈内字段，你仔细看一下原先的数据格式，修改后可以用外部导入数据。

yjyidfk

谢谢,但是我还没有找到,相关的问题,看来我还有待提高,再次感谢

penghaifeng

"形状"中间有空格,"订单数量"中订单与数量用回车换行.