Thank you so much for this great tutorial! I was absolutely stuck trying to union multiple google sheet data sources in desktop until your video helped me realize that switching to prep was the way forward
OMG! Thank you so much! I'd been struggling with union of excel files on tableau desktop and was getting really worked up that it wasn't working. I'm new to tableau and data analytics as a whole so I was really upset that all my learning was in the mud. Again, thanks!
Hey Sheila! I'm glad it helped!! Just in case you didn't know, I just went LIVE with my new website and the new course there teaches Unions and Joins in great detail using real world data (Days away from being added)! There's also a FREE starter course there to get your beak wet :) jellyman-education.thinkific.com/courses/getting-started-with-tableau You can check it out the full course at the following and even get a 50% discount using the coupon code JELLYMANUA-cam: jellyman-education.thinkific.com/courses/tableau-desktop-beginner-to-expert
With this method of union through tableau prep is there a way to have this union refresh dynamically (automatically) as my google sheets are being constantly updated. Or would I need to re-run the union in tableau prep every time I wanted to run the data and present it in tableau?
So you can publish your Prep flow to Tableau Online and then run schedule. It will then automatically perform the union. It’s called Tableau Prep Conductor. Let me know if you need more information
@Jellyman Education Hi! in power bi there is an option to append data, it appends the matching fields and adds to the right the non matching fields... is that possible in tableau?
I am struggling please help ! I have two different organizations incident management data in data source A & B respectively (live data sources). I need to present a consolidate view of total incidents and its related metrics as one combined organization which means I need to basically union the two data sources but the challenge is, there isn't any unique field to blend or build the relationship on. What approach should I follow?
Hi @jellymaneducation6168 Thank you for your great video. I have a question below: I have 2 Excel files (A and Bx) with the same column format. B file has more values data than A file. That means B file has the same and different values data as A file. Then how can I union ONLY different values data from them (A and B files). Normally, Union will merge all data which means some data values are double or multiple times. I only need unique values of data Hope you can help me with that case. Thanks
How about if I have a folder and every day new file is copied - can I point to the folder instead of individual file? (I'm migrating from PowerBI to Tableau)
Firstly, I applaud you for migrating from Power BI to Tableau!! As the old man in Indiana Jones and the Last Crusade remarks...."You have chosen Wisely!" You can point to the folder when performing a wildcard union. In your case however it depends on whether this new file is "unioned" to all others in the same folder...or....you want Tableau to take the latest file you've uploaded into that folder only.
Liked your vids. “Google” cannot be pronounced as “Gooshle” coz it was based on the noun google which is 1 followed by a hundred zeroes 😊. By the way, can you make a video how to optimize union for multiple Excel files where the it is stored in multiple Excel Worksheets - dealing with old way Excel management.
In the context of Tableau Prep they're the same thing. In terms of data, the correct term is Union which is the common term in our field. The word Add in Tableau simply means to trigger a union
Thank you so much for this great tutorial! I was absolutely stuck trying to union multiple google sheet data sources in desktop until your video helped me realize that switching to prep was the way forward
OMG! Thank you so much! I'd been struggling with union of excel files on tableau desktop and was getting really worked up that it wasn't working. I'm new to tableau and data analytics as a whole so I was really upset that all my learning was in the mud. Again, thanks!
Hey Sheila! I'm glad it helped!! Just in case you didn't know, I just went LIVE with my new website and the new course there teaches Unions and Joins in great detail using real world data (Days away from being added)! There's also a FREE starter course there to get your beak wet :)
jellyman-education.thinkific.com/courses/getting-started-with-tableau
You can check it out the full course at the following and even get a 50% discount using the coupon code JELLYMANUA-cam:
jellyman-education.thinkific.com/courses/tableau-desktop-beginner-to-expert
This helped a lot in using unions in tableau online. Please do some union instructions in tableau online.
thank you for the answer. i’m glad there’s a away to it.
Any time!
With this method of union through tableau prep is there a way to have this union refresh dynamically (automatically) as my google sheets are being constantly updated. Or would I need to re-run the union in tableau prep every time I wanted to run the data and present it in tableau?
So you can publish your Prep flow to Tableau Online and then run schedule. It will then automatically perform the union. It’s called Tableau Prep Conductor. Let me know if you need more information
@Jellyman Education Hi! in power bi there is an option to append data, it appends the matching fields and adds to the right the non matching fields... is that possible in tableau?
Yes! That happens automatically
I am struggling please help ! I have two different organizations incident management data in data source A & B respectively (live data sources). I need to present a consolidate view of total incidents and its related metrics as one combined organization which means I need to basically union the two data sources but the challenge is, there isn't any unique field to blend or build the relationship on. What approach should I follow?
Hi @jellymaneducation6168
Thank you for your great video. I have a question below:
I have 2 Excel files (A and Bx) with the same column format. B file has more values data than A file. That means B file has the same and different values data as A file. Then how can I union ONLY different values data from them (A and B files).
Normally, Union will merge all data which means some data values are double or multiple times. I only need unique values of data
Hope you can help me with that case.
Thanks
How can I move a dashboard from one tableau server (we use as prod) to another (we use as dev) with a snowflake data source?
Man, you saved my ass !! 👍👍👍
is unioning data from different data source will not work in Tableau desktop.?
Hi ..
How is career in tableau?
How about if I have a folder and every day new file is copied - can I point to the folder instead of individual file? (I'm migrating from PowerBI to Tableau)
Firstly, I applaud you for migrating from Power BI to Tableau!! As the old man in Indiana Jones and the Last Crusade remarks...."You have chosen Wisely!"
You can point to the folder when performing a wildcard union. In your case however it depends on whether this new file is "unioned" to all others in the same folder...or....you want Tableau to take the latest file you've uploaded into that folder only.
Liked your vids. “Google” cannot be pronounced as “Gooshle” coz it was based on the noun google which is 1 followed by a hundred zeroes 😊.
By the way, can you make a video how to optimize union for multiple Excel files where the it is stored in multiple Excel Worksheets - dealing with old way Excel management.
Hahahahaha. My jokes are so silly sometimes.
What is the difference between add and union? You went through that part too quickly.
In the context of Tableau Prep they're the same thing. In terms of data, the correct term is Union which is the common term in our field. The word Add in Tableau simply means to trigger a union
I spend the whole morning struggling with the stupid union and realized it cant be don't anymore
I've been there. It does get annoying. I prefer to do my unions and data prep on Tableau Prep
@@jellymaneducation6168 yes. No choice. Thought I can just settle everything on tableau desktop alone.
what an absolute piece of crap -- MS Access can union two different sql database, but tableau can't ???
piece of garbage
I know! My response exactly the first I tried. I kept thinking I was doing something wrong.