search

chrisamccoy / google-refine

Automatically exported from code.google.com/p/google-refine
Other
0 stars 1 forks source link

Text Facet does not work properly if the First Column of an Import is Empty #485

Closed GoogleCodeExporter closed 8 years ago

GoogleCodeExporter commented 8 years ago 
What steps will reproduce the problem?
1. Pls import the attached file
2. Do a Text Facet on Category
3. Select "Partner" in the Text Facet
4. The Result would show both Partner and Judge

What is the expected output? What do you see instead?
There should only be 1 result based on the above selection

What version of Google Refine are you using?
google-refine-2.1-r2136

What operating system and browser are you using?
Windows XP , Firefox 7.0

Is this problem specific to the type of browser you're using or it happens
in all the browsers you tried?
This problem appears in both Chrome and Firefox

Please provide any additional information below.

Original issue reported on code.google.com by chenjenn...@gmail.com on 18 Nov 2011 at 1:12

Attachments:

GoogleCodeExporter commented 8 years ago 
Are you in Row mode or Record mode?  It sounds like the latter.  Google Refine 
interprets spreadsheet rows with empty leading cells as part of a pseudo-record 
with the row(s) above so that you can do things like:

Name    Roles
Smith   Partner
        Judge

If you switch to Row mode, the facet will work the way you expect.

Original comment by tfmorris on 18 Nov 2011 at 9:02