操作步骤如下:
1、添加文件数据集,如图所示:
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/5ab5c9ea15ce36d3c477f65732f33a87e950b161?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
2、如下图,依次勾选文件类型为excel,并选择文件,然后勾选设置第一行包含列标题。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/8cb1cb134954092385af17199a58d109b2de4996?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
点击确定后,即完成第一个excel文件的添加。如图所示:
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/0b46f21fbe096b630a15293704338744ebf8ac4d?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
3、同理,继续添加其他的excel文件。
4、添加完所有文件之后,需要将excel进行关联运算,这个需要使用单元格的过滤功能进行关联,如下图所示:
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/8d5494eef01f3a296100a2a99125bc315d607c88?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
上图中,双击B2单元格,即可弹出数据列窗口,选择过滤,然后可选列与后面的数据列的字段进行关联,比如本案例中使用序号关联。
选择方式如下图:
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/77c6a7efce1b9d16bfdfeb06fbdeb48f8c5464b8?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
这样,即完成多Excel的关联,同理,3个、4个甚至更多的excel关联均可采用此方法。