Thanks Mike for the reply.
Have tried with all the options, But when i join the data for in excel table data goes in columns i want everything in a single table as all the column headers are same in both sources.
I don't understand what you mean. Have you got a photo or something?
If all of your columns are identical, are you trying to merge the tables, or append them to each other?
If one of your tables just contains new records that need to be added to the other table, then you're not looking for a merge/join. You would just need to stack your two tables on top of each other.
No matter the situation, you've got two tables coming from different sources, meaning you can't merge them in Tableau. You can only do a data blend. The difference is laid out nicely here: https://community.tableau.com/thread/195684
Yes, you are correct, i want to stack them each other. Being one is in SQL & Other one in Excel, its difficult for me to stack it.
Yeah, I hear ya.
Currently, Tableau lacks this functionality. They're currently developing something called Maestro that will give a user greater control over data modeling before beginning analysis. It's still in beta form.
What you need to do is append (stack) your tables using some other tool, and then bring this new table in to Tableau. There are a ton of ways to do this, but I'll list the ones I would do, in order of ease.
1. Use Alteryx. This is a software that Tableau users love, and it's for data prep prior to analysis. No coding involved. It's mega expensive, but you can download a 2-week free trial to give it a spin. I recommend trying it out just for the sake of developing skills in something that is very useful. If you're not interested though, this is overkill for your particular scenario.
2. Code. Not sure if you're proficient in any languages, but appending two tables with identical columns is super easy with a couple lines of SQL, python, or R. And they're all free. But you need to know them.
3. Power BI. This is Microsoft's version of Tableau, and you can download a free trial. It can connect to both of your data sources, and appending them is as easy as selecting one table, clicking append, selecting the second table, and bam - export your new table.
4. Use Tableau in a quick and dirty way. Take your table from the SQL server. At the top left, select Data>>Export to CSV. This might take quite a while depending on the file size. When done, take the csv and simply copy paste it underneath your excel file. Now your excel file will have everything you need.
Hopefully one of these work for you.
Thank you Mike for such detail clarification. This is really helps.
Will try to work with Alteryx.