Forum Discussion
QUERY ISSUES: Expression.Error: We cannot convert the value null to type Logical.
Anonymous Are you building any additional conditional columns or expression where a comparison of values essentially is null vs. null? Or is this a simple connection to Salesforce with no additional applied steps? Typically if this was a value only error it would just spit out that exception list, but there could be a core expression that is breaking the whole thing on load because it is only pulling a preview of the date (first 1000) rows in PQ.
I am having the null vs null error (I think). I created conditional columns that go look for a specific phrase in a text column that has mutiple comma seperated entries - thus producing a column with only the desired text in it. Some instances where I get a 'null' I see that the source column is null HOWEVER when there is text in the column but NOT the text I am seeking I get an error.
What advice might you have?