My assumption from various sources over Google: Join is a process where in we combine the datasets based on any common column Data blending is a process where we concatenate the datasets from different sources which don't have common columns
hii pavan! why it is not coming to me i was just joining the two tables of same excel file have a same common field like how it was appeared on your page as soon as you import the data in tableau page like sheet1 on the other page in place of joining the the two different files
Hey, I think Data Blending comes into picture when we work on two/multiple Data source. whereas Join is when we join two or more sheets within the same Data source. Hope it helps!
Hey 👋 You have said in last of this video that you have discussed types of joins in previous videos, But when I reach to your Tableau combined files, which consists of 87 videos. I haven’t found videos on joins, Can you provide me a video on Joins and unions. I m waiting for your response.. Thank you
In cross data base join it takes data from different sources (here from the example u gave ... It's Excel and notepad) Data blending also do the same.. What's the difference??? Between the two?
The equal sign here is not for assigning or comparing as compared to what we do in other programming languages. It is used to join two tables which share the same column name. A you can also see in the video @ 4:26 the column from sales table is Product ID and the column from products table is mentioned as Product ID (Products). If it' still not clear to you then just google joining two tables in SQL. You will get your answers
Nice video and explanation. But One question, what if i have a table whit PRODUCT and here as is ID, then other table whit SALES and os ID, but the ID of both was in other table. Só how can i join?
Sir can u solve this....................Cross join select t1.id,t2.id,t1.pattern from t1 cross join t2; Right join Select t1.id,t2.id,t1.pattern, t2.patern from t1 right join t2 on t1.pattern =t2.pattern Left join Select t1.id,t2.id,t1.pattern from t1 left join t2 on t1.pattern= t2.pattern;
I'm trying to auto join two MS excel files, they both have a common field called "date" and ticker" but when I select the second data source the information doesn't auto join like your demonstration. Can you help me using Tableau Desktop 2021.1.2 64 bit
To Get Certification, Click Here: bit.ly/43cTRUQ
Use coupon "UA-cam12" to get ‘’FLAT 12%’’ OFF at Checkout.
It would be really good if we get the difference between Cross data base join and Data blending
This is very helpful information. Thanks for sharing.
Great explanation...the joins video u mentioned, I couldn’t find in 87 videos...please help
Same here. I did not find any videos of join before this one.
This is very helpful.thanks for sharing
My assumption from various sources over Google:
Join is a process where in we combine the datasets based on any common column
Data blending is a process where we concatenate the datasets from different sources which don't have common columns
Is this correct??
I too have same doubt
Once please check again...
In blending also, we do need a same common column or a linking field.
Where can I find the dataset files for the entire course (87 tutorials)?
Ok, so Cross DB joins are the sames a joins just that we can connect with various data source. Am i right?
hii pavan! why it is not coming to me i was just joining the two tables of same excel file have a same common field like how it was appeared on your page as soon as you import the data in tableau page like sheet1 on the other page in place of joining the the two different files
How i can get text file data in my laptop. I am able to add text file because the data is not available in my laptop?
Hi!
When I add a CSV file relationship box pops up instead of join. What is a difference between join and relationship?
where can i find the data files product.csv and sales.xls?
Please mention the link to these datasets and please let me know if joints work in tableau public or not.
what is difference between cross data base join vs data blending?
Hey, I think Data Blending comes into picture when we work on two/multiple Data source. whereas Join is when we join two or more sheets within the same Data source. Hope it helps!
@@ayushagarwal2961 as said there are two different data sources here... One is excel and other is csv file.
Its still unclear for me.
What is the difference between cross join and blending?
I don't find the data files (excel as well as CSV files).
sir you have missed one more video to upload on youtube, ie., joins overview
Hey 👋
You have said in last of this video that you have discussed types of joins in previous videos,
But when I reach to your Tableau combined files, which consists of 87 videos.
I haven’t found videos on joins,
Can you provide me a video on Joins and unions.
I m waiting for your response..
Thank you
I'm also waiting, as I'm following your videos in order.
@@nathaliec7436 search the topic the concepts of inner join outer join remains same despite of its usage in different softwares
Nothing but good stuff :)
Nothing but good tutorial 😃
nice explanation of concepts. please share selenium tutorial also
Is it possible to do an incremental refresh on cross data base joins?
I couldn't find the join video in 87 tutorials
If anybody can tell, how can I find all the data Pavan Sir is using in this Video? Help would be much appreciated.
How get the data set file Excel and csv plz suggest
Hi Pavan where to download products 2017 and sales 2017 files for practice
In cross data base join it takes data from different sources (here from the example u gave ... It's Excel and notepad)
Data blending also do the same..
What's the difference??? Between the two?
the joint video is not available please share
why the first dataset (Sales ) is not the first dataset after doing the join. Can you explain please
you've said see previous video for more about inner joints but there is no explaination of it in any previous video
What does the equal sign in the Product ID "=" Product ID mean? what happens if i put Product ID > Product ID instead?
The equal sign here is not for assigning or comparing as compared to what we do in other programming languages. It is used to join two tables which share the same column name.
A you can also see in the video @ 4:26 the column from sales table is Product ID and the column from products table is mentioned as Product ID (Products). If it' still not clear to you then just google joining two tables in SQL. You will get your answers
can anyone share the link of products.csv and sales.xsl datasets .
Nice video and explanation. But One question, what if i have a table whit PRODUCT and here as is ID, then other table whit SALES and os ID, but the ID of both was in other table.
Só how can i join?
I done the same ,but they are not joining,whats the issue plz tell
Please provide the link of where the data files Thanks a million
How should I get those data files (i.e. .CSV and Excel file) Please suggest or anyone can help me to get that file please. Thank you in advance.
Could u provide joins video
Sir pls send the url of inner outer left and right joins video
where are data files???
Sir can u solve this....................Cross join select t1.id,t2.id,t1.pattern from t1 cross join t2;
Right join
Select t1.id,t2.id,t1.pattern,
t2.patern from t1 right join t2 on t1.pattern =t2.pattern
Left join
Select t1.id,t2.id,t1.pattern from t1 left join t2 on t1.pattern= t2.pattern;
Please provide the data files both csv and exel
thanks
When i try to join , it does not shows a join but a simple line
Can anyone help mr
Sir,Can you provide the dataset to download?
can anyone share the link for data files?
Anyone please share the link for data files used in this video....
Plz inner,right left,full joins video
I'm trying to auto join two MS excel files, they both have a common field called "date" and ticker" but when I select the second data source the information doesn't auto join like your demonstration. Can you help me using Tableau Desktop 2021.1.2 64 bit
Same issue is with me also.
I'm already used to use "noting but" phrase
Send link for practice
Could you provide data files
Products is not excel , is CSV
Wao
I hv the same question
Please send me files
It's urgent sir
Goof
.
Please provide the datasets