Forum Discussion

Saxon202202's avatar
Saxon202202
Helper III
3 years ago

Lookup reference multiple columns

Hello, I have two tables are data and report. In data table the following columns are Result, Reference1, Reference2. In report table the following columns are Reference1 and Reference2. I am try...
Need Help
katika555's avatar
katika555
Resolver I
3 years ago

Saxon202202  hi, 
Instead of using

COALESCE(RESULT1,RESULT2,RESULT3) in Report Table Result1 use 
If(isblank(RESULT1)&&NOT Isblank(RESULT2),RESULT2,RESULT3)
Saxon202202's avatar
Saxon202202
Helper III
3 years ago

katika555 ,

 

Thanks for your reply and suggestion but still I have incorrect result were blanks in both reference1&2 . I am tryinng to apply the if statement but still not working. 

Any suggestion and help much appreciated. 

  • katika555's avatar
    katika555
    Resolver I
    3 years ago

    Saxon202202 messed Reuslts I cant understand what you need to get.

    If you add separate columns for results like that may be would be more clear:

    • Saxon202202's avatar
      Saxon202202
      Helper III
      3 years ago

      Thanks for your help and sorry for the late respones. 
      I agree maybe that's simple way to do it but I don't want to create a too many columns to achieve the result. Is there any alternative suggestion.