i have 3 tables same database common column transaction number is better to join or data blend

0 votes
i am new to Tableau, i have 3 tables (A,B,C) using same database, A table contains Transaction number, B table contains Transaction number,Claim_id  and C table contains Transaction number,Claim_id.

in tableau, we use 3 tables based on requirement creating reports, but which better join or Data Blending concept?

we use data blending A is primary and B,C are Secondary but we taking B table Claim_id count based on A table column Payer.

top 10 payer by claim_id count it is showing wrong.

can you please explain which is better.
Aug 16, 2019 in Tableau by vnk

1 answer to this question.

0 votes

I would suggest going with joins for a transactional data source to avoid duplication or wrong calculations.

Wrong details would be shown while blending due to a different level of granularity or aggregation. Data blending should be used when you don't have duplicated values in data sources and to prevent the creation of a new source from existing sources.

When to Substitute Joining for Blending

1. Data needs cleaning.

If your tables do not match up with each other correctly after a join, set up data sources for each table, make any necessary customizations (that is, rename columns, change column data types, create groups, use calculations, etc.), and then use data blending to combine the data.

2. Joins cause duplicate data.

Duplicate data after a join is a symptom of data at different levels of detail. If you notice duplicate data, instead of creating a join, use data blending to blend on a common dimension instead.

3. You have lots of data.

Typically joins are recommended for combining data from the same database. Joins are handled by the database, which allows joins to leverage some of the database’s native capabilities. However, if you’re working with large sets of data, joins can put a strain on the database and significantly affect performance. In this case, data blending might help. Because Tableau handles combining the data after the data is aggregated, there are fewer data to combine. When there are fewer data to combine, generally, performance improves.

For more difference between data blending and joins, read this blog.


Hope this helps!

answered Aug 16, 2019 by Cherukuri
• 32,490 points

Related Questions In Tableau

0 votes
1 answer

Is it possible to join tables on the basis of some calculated field in Tableau?

@Ammy999, You can not perform join in ...READ MORE

answered May 16, 2018 in Tableau by Mathew1810
+1 vote
1 answer

Is it possible to access or install tableau desktop insde tableau server?

Try to understand this, Tableau Server and ...READ MORE

answered Mar 29, 2018 in Tableau by xyz
• 1,560 points

edited Mar 29, 2018 by xyz 131 views
0 votes
1 answer

How to calculate profit when cost and revenue are in same column?

You can create the following calculated fields: Profit: SUM(IIF([account_category] ...READ MORE

answered Apr 10, 2018 in Tableau by Atul
• 5,540 points
0 votes
1 answer

How to split or divide the grouped data into multiple graphs?

One of a simple approach is to ...READ MORE

answered Apr 17, 2018 in Tableau by xyz
• 1,560 points
0 votes
1 answer

Selection Bias

Selection bias is the bias introduced by the ...READ MORE

answered Jul 11, 2018 in Data Analytics by CodingByHeart77
• 3,720 points
0 votes
1 answer

Using Real Time flume Data for Analysis

By using MorphlineSolrSink we can extract, transform ...READ MORE

answered Jul 17, 2018 in Database by kurt_cobain
• 9,320 points
0 votes
1 answer

Channel in Flume

 A transient store that receives the events ...READ MORE

answered Jul 17, 2018 in Big Data Hadoop by Ashish
• 2,650 points
0 votes
1 answer

How do I become a data scientist step by step?

I am assuming that you are a ...READ MORE

answered Jul 26, 2018 in Data Analytics by Abhi
• 3,680 points
0 votes
1 answer

How to fetch the previous value in a column or row?

Hi Sindhu, You can use LOOKUP() or PREVIOUS_VALUE() in ...READ MORE

answered May 22, 2019 in Tableau by Cherukuri
• 32,490 points
0 votes
2 answers

How can I display filtered value and grand total in the same sheet?

You can create a fixed calculated field ...READ MORE

answered Sep 15, 2018 in Tableau by Machdata
• 340 points