Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

15 querires are blocked errors

I keep getting this error when running queries.  How do I fix this?  

 

2 Replies

  • mussaenda's avatar
    mussaenda
    Icon for Community Champion rankCommunity Champion

    Hi Anonymous ,

     

    you are doing column conditions where there are values null but you are not giving instructions how to handle the them.

     

    You can either assign a condition for null values or if not needed, use the try-otherwise to avoid these issues.

    this function is like iferror in excel.

     

    try (your full condition here) otherwise (what to do if error is found)

  • JoeBarry's avatar
    JoeBarry
    Icon for Solution Sage rankSolution Sage

    Hi Anonymous 

     

    Without more information, it's quite difficult to help. From what we can see from your screenshot, there issues in the tables with transformations in columns.

     

    Thanks

    Joe