Topics started by paola
What is whitespace? Whitespace is a character that will occupy space on a page but does not correspond to a visible mark in your data. At times, the values in our table will have whitespace without us knowing it’s there! How does whitespace affect my data? Let’s say we have a basic user table that looks like this: | User ID | Gender | Hometown | |---------|--------|----------| | 1 | F | Atlanta | | 2 | M | Houston | | 3 | M | Denver | | 4 | F | San Fran | It doesn’t show any whitespace in our values, but what will happen if we filter on the Explore level where Hometown = ‘Denver’? We’d expect for Looker to return the third row in our table, but instead we get No Results. Why? This could be due to leading or trailing whitespace in ‘Denver’ that we’re not seeing because Looker “strips” it out on the front end. Whitespace is eliminated from the front end of Looker meaning that it will be removed from the display of the data table and
Already have an account? Login
Login to the community
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.