Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

QUERY ISSUES: Expression.Error: We cannot convert the value null to type Logical.

Hi Folks,   I know this has been asked loads before and I have read the threads but nothing is working for me.... I have 2 tables pulling from Salesforce Objects, a Header Table and a Product Table...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

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's avatar
Anonymous
Not applicable
7 years ago

Anonymous 

 

I had it formatted as text but I will try that!

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    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!