3 Replies Latest reply on Jan 3, 2018 4:28 PM by suvas.chandra

    Tableau Custom SQL Field Limitation

    suvas.chandra

      Is there any column number limitation of Tableau custom SQL for MS Excel ?

       

      If I write this it works:

       

      SELECT *,
      1 AS [Copy]
      FROM [Tableau Sheet$_xlnm#_FilterDatabase]

      UNION ALL

      SELECT *,
      2 AS [Copy]

      FROM [Tableau Sheet$_xlnm#_FilterDatabase]

       

      But if I write this, it doesn't work:

       

      SELECT *,
      1 AS [Copy]
      FROM [Tableau Sheet$_xlnm#_FilterDatabase]

      UNION ALL

      SELECT *,
      2 AS [Copy]

      FROM [Tableau Sheet$_xlnm#_FilterDatabase]

      UNION ALL

      SELECT *,
      3 AS [Copy]
      FROM [Tableau Sheet$_xlnm#_FilterDatabase]

       

       

      If I use individual fields instead of taking ALL from the database, I can make it work. But I used only 5 fields.

       

      Is there any limitation for this ? I have used both live and extract connections. What is the best way to resolve this ?