Sorry couldn't attach excels. below is how the data looks
Data source 1: Attribute
Product Attribute Value Cost Retail
A Brand Levis 10 15
A Color Blue 10 15
B Brand Wrangler 12 20
B Color Blue 12 20
C Brand Levis 14 23
C Color Black 14 23
Data Source 2: Like Products (Flag = 1 means Prod and Products are Like)
Prod Like_Product Flag
A A 2
A B 1
A C 0
B B 2
B A 1
B C 0
C A 0
C B 0
C C 2
So what happened when you set up the data blend? Can you post a packaged workbook with the data blend you set up?
Please find attached the tableau workbook.
In this example i was trying to put an action from sheet1 to sheet 2 on selected field ---
data source -attribute, field - Product to data source - Like Prod ,field - Prod.
I have set up the blend as i was trying before.
Please look into it
Forum.twbx.zip 29.7 KB
Since there are no actions in the workbook, I am not sure what you tried. I was able to create a highlight action--however, it looks like blending on Product and Prod would not give the proper result. Blending on "Product" and "Like Product" seemed to produce the correct result. See the attached.
A good test to see whether data blending will work properly is to pull your dimensions into a text table on one sheet, and do the same in another sheet for your secondary source. If the two match, data blending should work properly. In this case, "Product" and "Like Product" would show a match, while "Product" and "Prod" would not.
If this is not what you're looking for, then I do not understand the problem.
Forum ML.twbx.zip 31.1 KB