6 Replies Latest reply on Jan 10, 2017 9:48 AM by Jason Au Yong

    How to reshape survey data, including "check all that apply" questions, that has been uploaded into SQL Server?

    Andrew Masnyj

      Hello,

       

      I am working with survey data trying to visualize various measures, including for example, "Licenses and Designations currently held by financial advisors".  My firm has been using Excel, but is migrating data to SQL Server.  SQL Server shows great promise as a central data repository ensuring up-to-date data and alleviating version control, however, I am wondering how I would be able to best reshape the data.  Primarily, I am concerned with combining fields.  I reached out to Tableau Support, and they were able to give me a preliminary solution of using Custom SQL to reshape on the fly.  I would greatly appreciate it if anyone has any added experience with either Custom SQL or survey data reshaping from SQL.

       

      Thanks!