Tableau教程_數(shù)據(jù)聯(lián)接Join與數(shù)據(jù)融合DataBlending2

1、關(guān)注:itableauitableau該帖子內(nèi)容基于Tableau 9.0繼續(xù)對(duì)數(shù)據(jù)融合進(jìn)行剖析， 您需要對(duì)前一個(gè)關(guān)于內(nèi)連接，左連接的帖子熟悉，同時(shí)也請(qǐng)您耐心的把這個(gè)帖子看完，一定受益匪淺表關(guān)聯(lián)是基于行級(jí)別的，但是數(shù)據(jù)融合數(shù)據(jù)源關(guān)聯(lián)是基于分組級(jí)別的，到底區(qū)別在哪里，來兩個(gè)例子師范一下例如數(shù)據(jù)很傻，能說明問題就好 Table 1ArealD AreaName1EAST2WEST3SOUTH4NORTHTable 2AreaIDYearSales120211220211320211420211120211220211320211420211行級(jí)別的關(guān)聯(lián)，這樣關(guān)聯(lián)的結(jié)果就是一張有8條數(shù)據(jù)的表Area

2、LDAreaNameAreaEDYearSales1EAST5- 1202112XVE&T-2202113SOUTHy- 320211+NORTH JV420211 12021120211、320211、420211數(shù)據(jù)融合，必須有主數(shù)據(jù)表和輔數(shù)據(jù)表，輔表會(huì)依據(jù)關(guān)聯(lián)維度聚合， 不可能比數(shù)據(jù)源關(guān)聯(lián)關(guān)系中的粒度更細(xì)AruaJD,VeaXaineAreaLDSales1 EAST12JWESTJ223 SOUTH- -X324NO史TH- 42我們將通過下面的例如繼續(xù)剖析數(shù)據(jù)融合，分別在兩張數(shù)據(jù)庫(kù)中寫入Superstor中的Order表，兩張表一模一樣兩個(gè)EXCEL亦可：1、分別連接兩個(gè)數(shù)據(jù)

3、庫(kù)的中的Orders表，然后重命名數(shù)據(jù)源為ds1, ds2 ,ds1為主數(shù)據(jù)源，ds2位輔助數(shù)據(jù)源，編輯數(shù)據(jù)源關(guān)系，duct category = duct category2、分別雙擊ds1中的Product Category, Sales,繼續(xù)雙擊ds2中的Sales,可以看到數(shù) 據(jù)一切正常帶有藍(lán)色對(duì)勾的數(shù)據(jù)源表示主數(shù)據(jù)源，橙色表示輔助數(shù)據(jù)源輔助數(shù)據(jù)源中，有橙色鏈條符號(hào)的是指關(guān)聯(lián)字段功能區(qū)中有橙色對(duì)勾數(shù)據(jù)源標(biāo)志的表示該字段來源于輔助數(shù)據(jù)源Product CateccryProduct csaietAbe良#AbeAbeAbeAbeAbe# #島AbeAbe1&a

4、mp;ADcCity Cgtcmer I。Cuttc mcrNwmf CutcmerSegmentOrderDate Chrde-TDOKdp-PrinrityPostalCodePiodurt Cateq try ProductCortainerProduct NameProduct SubCategoryRegicn Row心Ship DateShip ModeStait or ro7ince芟且名稱，寶魚去稱Fumi turt3 17862Abe白團(tuán)大八AR123度量埴怠計(jì)信用網(wǎng)TtfSales)AteIBonceSupplies2.25Br3262 255 326Techndagy3,

5、514,99235149323、我們將ds1中的Product sub-category拖至行功能區(qū)Product Category的右側(cè)，可以看到ds2中的Sales聚合層級(jí)仍舊在Product Category,也就驗(yàn)證我所說的分組級(jí)別的關(guān)Sales導(dǎo)星軍笄ft I(3SAI大小深至唇可.二具控不竟言言StfSales),ri-rfSales)ProductProduct Cate.Cate. ProductProduct Sub-CategorySub-CategorySalesFurnitureFurnitureBoot二百三日三507.44J7E ,624Chairs &Ch

6、atrnrrats3.178,624百二4/4/3J78.6241.3.178,6242.25S,3Z6Appliances2.255.32CEnfftlopes2.255,326Labels2 3,4502.258 3262.2S8.322.253.326S.6642.25 32640,4292,250.32650-5,7052.25E,326490.84t3.514.99266-1,2123314的Office MschFres1.218,6573.514,5321.144,2731.144,2732S3.800103,252103,252Abe123AOfficeOffice Furni

7、shingsFurnishingsTables法.5 k147,921147,921Etorage & QrgamzstiDfiComputer PeripheralsCopiers and FaxOfficeOfficeSupplierBinders and Binder Xiessari.Rutob-er三Scisadrs Rulers and TrimmersTelephones and Communica,5643,514.932腳本解析(大概描述后臺(tái)運(yùn)行的邏輯，不是原腳本)：select ds1.Product Category,ds1.Product Sub

8、-Category,ds1.Sales,ds2.Salesfrom(select Product Category, Product Sub-Category, SUM(Sales) as Sales from Ordersgroup by Product Category, Product Sub-Category) ds1 left join(select Product Category, SUM(Sales) as Salesfrom Ordersgroup by Product Category) ds2 on ds1.Product Category = ds2.Product C

9、ategory4、將ds2中Product sub-category拖至行功能區(qū)中ds1 Product sub-category的右側(cè)，看到該字段全部變?yōu)樾翘?hào)，該效果等效于Tableau的attr()函數(shù)腳本解析(大概描述后臺(tái)運(yùn)行的邏輯，不是原腳本)：select ds1.Product Category,ds1.Product Sub-Category,ds2.Product Sub-Category,ds1.Sales,ds2.Salesfrom(select Product Category, Product Sub-Category, SUM(Sales) as Sales from Ordersgroup by Product Category, Product Sub-Category) ds1 left join(select Product Category,case when min(Product Sub-Category) = max(Product Sub-Category) the min(Product Sub-Cate