So are we done with "Blend" once and for all ? What i want to ask is , if anyone can confirm , After Tableau 10.0 there is no feature called as "Blend" as Tableau can create "Join" across all Databases .

Is that a correct statement ?

Dear Pawan - This won't be correct statement, as blend works after aggregation, this is still a very powerful feature offering of Tableau and this would required in case two data set is not at the same grain.

Thanks - Manideep

Hello - Let's take the following two Data Set are in different Grain. First one is Sales data at Product Level and Daily and another Target data is at Country level and Monthly. Now if in one viz. we have to depit both in a bullet chart, then Blending comes preety handy and useful.

Thanks,

Manideep

Thank you Akriti. This is helpful.

I'm trying to do join two tables..both are in two different Oracle Database. So will cross data join work?

Thank you

It worked. Earlier i was not able to join because the data types on the join columns in not same ...one is decimal and other one is whole number..but when i changed the type to string using To_Char I was able to join. Just stating so if come across this issue this will be helpful.

Thank again Akriti.

Akriti,

This might not be related to the above post but when I doing cross data join I'm getting error up saying unable to materialize temporary table/ Unable to create extract.

I looked up on tableau help. Link below:

Error "Unable to materialize temporary table" Joining Data Sources | Tableau Software

Not sure how to resolve this. I'm not seeing any antivirus on my machine. Any thoughts?

The reason I want to cross data join is because the calculations will be easy to bring back the data I need. For example in DSource A I've counts and in DSource B I've a flag to filter on to get the counts from  Data source A. If  data blended, it is creating a big/crazy workaround unless there is an easy way to do this?

My calculation should be something like this. If DS(B).column = "Yes' then DS(A).counts ( this is not working if data blended)

Easy way i know is doing cross data join but it is not creating an extract.

Thank you!

Yup. I'm doing the same way. Probably with the data I think.I just created an extract as a new data source (data blended)on the Table that is giving me the issue ..then it is has no issues creating extract alone..but when doing cross data with the primary source it is throwing me that error..Unable to materialize temporary table

Attached the issue I'm getting. I'll continue to look into why it is causing the data issue. Anything I find out will share.

Will cross database joins still be available if I connect to a Tableau Server 9 data source using Tableau Desktop 10?

Kind regards,

Victor.

You can't join with published datasources but if you are logged into Server just for user functions then it will still work.