Update: Tableau 10.2 is here! Download now to try out the feature outlined below.

Over the past few releases, we’ve invested heavily in data prep, making it easier to connect Tableau to your data and get to your analysis faster. With Tableau 10.2, we’re enhancing some of our existing functionality. We’re extending features like union to work with more connectors. We’re also improving our date recognition capabilities.

Union updates

Tableau 10.2 includes database union to help you leverage your database structure more efficiently. Many database admins split up data by region, date, or channel for both business and performance reasons. To piece that data back together, analysts had to write unions in custom SQL or ask admins to build custom views. With Tableau 10.2, you can now create those unions with just a drag and drop for several new connectors!

  1. SQL Server
  2. MySQL
  3. Oracle
  4. Postgres
  5. Redshift
  6. Vertica
  7. BigQuery

Here’s a bikeshare data set that’s been uploaded to SQL Server. The original files were partitioned by quarter, and the database admin preserved that structure. With a simple drag and drop, I can now union database tables as easily as I can union files:

I know that my admin is going to upload data quarterly, though, and I want my data source to automatically include those new tables. You’ll be glad to know that wildcard union is also supported for databases:

And of course, you can always use the “merge mismatched fields” feature to align columns. In this data set, the “Duration*” fields were all named differently, and should be coalesced:

This functionality isn’t available for all databases yet, but we’re adding new connectors in order of popularity. If you’re dying for your connector to be supported next, let us know in the comments and community forums!

Automatic DateParse

In Tableau 10.2, transforming data from a string to a date type is easy with Automatic DateParse. Just change the data type and Tableau will do all the heavy-lifting, no calculations required.

In this simple example, consider this baseball data set which has an integer “Year” column:

In earlier versions of Tableau, changing “Year” to become a date would yield all nulls, but in Tableau 10.2, you get actual dates!

And while simple cases now behave more intuitively, Tableau can handle a much wider variety of dates as well. When we analyzed Tableau public we found over 250 unique date formats!

To analyze these dates in Tableau, you previously had to write non-trivial DATEPARSE calculations. Here’s a sampling of date strings that you previously would have had to write calculations for:

Here are Tableau’s new recognized dates!

There are a couple of caveats to note about our new capabilities. The first is that, under the hood, Tableau is now using a DATEPARSE calculation instead of a DATE or DATETIME cast. While the DATEPARSE calculation is not new, in Tableau 10.2 is generating these complicated calculations automatically behind the scenes.

You’ll also be pleased to note that this works on calculated fields as well! In an NFL data set, I’ve got the date encoded in the game ID, so I SPLIT it out into a separate column.

I can then cast that SPLIT column to a date, and check the resulting calculation:

Try Tableau 10.2

With database union, we’re adding prep functionality to new connectors, making it easier for database users to get to their analysis faster when data is partitioned into multiple tables. With our smarter date recognition, Tableau is now able to recognize hundreds of new date formats, reducing the need to write complicated date calculations. These features help expedite your data prep and cleaning, enabling you to spend more time in analysis.

Check out our beta program to learn more and sign up. The beta program is available for existing Tableau customers. Customers with an active maintenance license can upgrade for free when Tableau 10.1 is released.

And visit our Coming Soon page to learn about all the features we're planning for Tableau 10.2.

Learn more about Tableau 10.2

Tableau 10.2 beta is here
Leverage the power of Python in Tableau with TabPy

You might also be interested in...

Comments

Dr.Unity can help get ex lover back fast.
My ex and I were friends for 8 years before we finally started dating. We really had a lot of fun together and I truly believe we can be great for eachother. Yet the timing just wasn't right. We dated for almost 2 years and during that time we both were in university and working so it was difficult to see eachother. And due to that we started fighting and eventually it led to him cheating on me because he was drunk at a party. We tried to move past it but in the end the distrust was too hard for us to keep moving forward and my anxiety caused him to break up with me. It has now been 3 months and we just started talking. He said he misses me and I told him I still have feelings for him but he said he isn't ready. What should I do? I needed help. As i was browsing through the internet i came across a website that suggested Dr.Unity can help get ex lover back fast and so on. So, I felt I should give him a try. I contacted him and told him my problems and he told me what to do and i did it and he did a spell for me. 11 hours later, my boyfriend came to me and apologized for the wrongs he did and promise never to do it again. Ever since then, everything has returned back to normal. I and my boyfriend are living together happily again. Dr.Unity is the best online spell caster that is powerful and genuine. If you have any problem contact him and i guarantee you that he will help you. Here’s his contact: Email him at: Unityspelltemple@gmail.com ,you can also call him or add him on whats-app: +2348071622464 ,His website: http://unityspelltemple.yolasite.com .

Tracey

Hey guys, Best & Powerful Love Spells To Get Your Ex Back Fast .
I'm so excited my broken Marriage has been restored and my husband is back after a breakup, After 2 years of marriage, me and my husband has been into one quarrel or the other until he finally left me and moved to California to be with another woman. i felt my life was over and my kids thought they would never see their father again. i tried to be strong just for the kids but i could not control the pains that torments my heart, my heart was filled with sorrows and pains because i was really in love with my husband. Every day and night i think of him and always wish he would come back to me, I was really upset and i needed help, so i searched for help online and I came across a website that suggested that Dr Unity can help get ex back fast. So, I felt I should give him a try. I contacted him and he told me what to do and i did it then he did a (Love spell) for me. 28 hours later, my husband really called me and told me that he miss me and the kids so much, So Amazing!! So that was how he came back that same day,with lots of love and joy,and he apologized for his mistake,and for the pain he caused me and the kids. Then from that day,our Marriage was now stronger than how it were before,All thanks to Dr Unity. he is so powerful and i decided to share my story on the internet that Dr Unity real and powerful spell caster who i will always pray to live long to help his children in the time of trouble, if you are here and you need your Ex back or your husband moved to another woman, do not cry anymore, contact this powerful spell caster now. Here’s his contact: Email him at: Unityspelltemple@gmail.com ,
you can also call him or add him on Whats-app: +2348071622464 ,
his website:http://unityspelltemple.yolasite.com .
Jessica, 26 years, Texas, USA.

Hello,

Hey guys my wife and I have been married for 15 years. For over five years I have been dealing with jealousy issues because of flirting and her having emotional type affairs with other men. I felt like my masculinity was in question and if I said the way she was acting bothered me, it seemed to make matters worse or I was accused of being controling. During this period I did state I wanted a divorce if the behavior was not going to end: texting men a night, leaving for the weekend without letting me know where she was going or not responding to messages. We do have a son and basically it's been him and I for the last year on the weekends. She disconnected completely from being a good wife and mother. In April she said she wanted a separation and I said no we need to get into marriage counseling. We did try that, but she was not very responsive and didn't give any effort. Afterward she was adamant about separation and divorce. I continued to say no and that we needed to save our family. She presented a separation agreement and I had to hire a lawyer. Because of the above behavior my lawyer suggested a private investigator. The investigator discovered my wife was having an affair with a close friend of the family who also is married with children. We know the extended families. I feel like I should tell this man's wife about what happened. This adultery has devastated me emotionally, I feel betrayed and I'm physically drained. I know my wife is passionate in terms of her sexuality, and I can't get the thought of them out of my head. It makes me question my own manhood, and I feel very inferior or that he must be a better lover or what ever. The problem is my wife pursued him. She would go to him and she lured him into this adultery. I felt this was coming for some time and could not stop it. She was not only lying to me but also to our son about what she was doing and where she was going. My family is important, my son loves her and as crazy as it sounds so do I. Can you respond with a course of action on how to proceed? I was still have a very huge place in my heart for her. so i searched for help online and I came across a website that suggested that Dr Ahmed can help solve marital problems, restore broken relationships and so on. So I felt I should give him a try. I contacted him and he told me what to do and i did it then he did a spell for me. 28 hours later, my wife came to me and apologized for the wrongs she did and promise never to do it again. Ever since then, everything has returned back to normal. I, my son and my wife are living together happily again.. All thanks to Dr Ahmed. as it is a place to resolve marriage/relationship issues, do you want to be sure if your spouse is being faithful to you or Do you want your Ex to come back to you Contact.: E-mail: Ahmedutimate@gmail.com or call/Whats-app: +2348160153829 save your crumbling home and change of grades its 100% safe. I suggest you contact him. He will not disappoint you.
David L. Ollis, 43yrs, UK


Add new comment

Subscribe to our blog