Forum Discussion

admin11's avatar
admin11
Memorable Member
4 years ago
Solved

Link Table for Customer get error msg

Hi All My AR table customer table unable to link with my SOURCE table.    i using this expression to link :- Customer = DISTINCT(UNION(ALL(AR[Customer/Vendor Code]), all(SALES[CUST_ID])) )   ...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi admin11 ,

     

    The reason for the error is that this column contains null values.

     

    Result after filtering out blank values

    Customer = DISTINCT(UNION(ALL(AR[Customer/Vendor Code]), filter(all(SALES[CUST_ID]),[CUST_ID]<>BLANK())) )

     

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

admin11's avatar
admin11
Memorable Member
4 years ago

VahidDM 

Thank you for  sharing.

I have try your expression , it still have error.

 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi admin11 ,

 

The reason for the error is that this column contains null values.

 

Result after filtering out blank values

Customer = DISTINCT(UNION(ALL(AR[Customer/Vendor Code]), filter(all(SALES[CUST_ID]),[CUST_ID]<>BLANK())) )

 

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

  • admin11's avatar
    admin11
    Memorable Member
    4 years ago

    Anonymous 

    Thank you very much for your help, it work fine now.

    Paul