Forum Discussion
QUERY ISSUES: Expression.Error: We cannot convert the value null to type Logical.
I had the same suspicion and did a remove empty on the mutual fields in the seperate queries... and still the same thing... I also judt did a formula of
if oppid=null then "y" else "n"
and then filtered on "y" and there was no nulls eitherway...
Anonymous When you are creating "Duns DISTI INC EXCL", is that datatype being set to logical? Maybe instead of setting the else as "Exclude" you should change that to null. If it is taking your "Y", "N" and setting to logical, then the "Exclude" text value will break that prior to your type transformation.
#"Custom Field Inc Duns / Disti" = Table.AddColumn(#"Merged Queries", "DUNS DISTI INC EXCL", each if [#"Acc.Include?"]="Y" or [#"PAP.Include?"]="Y" or [#"SP DUNS.Include?"]="Y" or [Disti Inc YN]="Y" then "Y" else "EXCLUDE"),
Anonymous
I had it formatted as text but I will try that!
Made some progress, it seems that my suspicion that the conditonal column started all the errors held true... I went about it a different way (a better way in hindsight) and now im just back the usual time out errors and web contents errors :P
Thanks for the advice!