KNOWLEDGE BASE

Group Displayed as "Null" after Grouping Rows


Published: 07 Jan 2016
Last Modified Date: 15 Mar 2017

Issue

When grouping dimension values a "Null" group is created, as well as the group created manually.

Environment

  • Tableau Desktop 
  • Excel

Resolution

In order to prevent this issue from occurring please use the Legacy Connector following the steps detailed below: 

1. On the start page, under Connect, click Excel.
2. To connect to the Excel file using the Microsoft Jet-based connection, in the Open dialog box, click the Open drop-down menu, and then select Open with Legacy Connection. The data source page appears.
 

Cause

Our Excel connector is asking for the column locale instead of Excel default locale.
Did this article resolve the issue?