iT邦幫忙

1

[Excel 2007] EXCEL sheet join sheet (Microsoft Query)

環境 : EXCEL 2007

準備2個EXCEL檔案,一個放結果,一個放來源,來源裡有2個sheet
Sheet cust
https://ithelp.ithome.com.tw/upload/images/20190614/20106764CRrI2hgQqY.png
sheet addr
https://ithelp.ithome.com.tw/upload/images/20190614/201067647AdfrJYos1.png
要把他們join在一起

開始吧

在結果那個EXCEL
https://ithelp.ithome.com.tw/upload/images/20190614/20106764CBm8mCKhVu.pnghttps://ithelp.ithome.com.tw/upload/images/20190614/20106764KocZjRq6QE.pnghttps://ithelp.ithome.com.tw/upload/images/20190614/2010676469liz00FQs.pnghttps://ithelp.ithome.com.tw/upload/images/20190614/201067646ITXKCbmPc.pnghttps://ithelp.ithome.com.tw/upload/images/20190614/20106764fPmXTRlyyV.pnghttps://ithelp.ithome.com.tw/upload/images/20190614/20106764FCcEVvhm1c.png
https://ithelp.ithome.com.tw/upload/images/20190614/20106764RXvyuYS2Yz.png
https://ithelp.ithome.com.tw/upload/images/20190614/201067641Nhbnnfmf4.pnghttps://ithelp.ithome.com.tw/upload/images/20190614/20106764LsggxFmlqT.png

left join

預設是inner join ,如果想要改成left join ,點連結線2下
https://ithelp.ithome.com.tw/upload/images/20190614/20106764Iiv8BrJyAD.pnghttps://ithelp.ithome.com.tw/upload/images/20190614/20106764XcS8vEjlwO.png


尚未有邦友留言

立即登入留言