LookML model join is using fields as numeric when they are both defiled as string

Hi All

I am getting the following error in a LookML model on a join - it seems to be trying to join post codes as numeric values, even though both dimensions are defined as sting in the respective views.

image
image
Any idea why this would be? and how to I get this fixed?

we are using a snowflake back-end.

I have tried to put a ‘to_char()’ conversion in (as below), but this does not seem to translate into the explore window (which is also wierd).

0 6 956
6 REPLIES 6
Top Labels in this Space
Top Solution Authors