Forum Discussion

jppuam's avatar
jppuam
Icon for Helper V rankHelper V
5 years ago
Solved

LEFT OUTER JOIN not working

Hello, i've a table A with the follow: code_ID    department     costs 1               chemistry        100 2               math                200 3               sociology         300 4      ...
Need Help
  • Jos_Woolley's avatar
    Jos_Woolley
    5 years ago

    If the matching is to be based on all 3 columns:

    NewTable =
EXCEPT ( Table1, Table2 )

    Regards

jppuam's avatar
jppuam
Icon for Helper V rankHelper V
5 years ago

Jos,

when i try to merge two query by code, ir gives me this error:

 

Expression.Error: The 'count' argument is out of range. What is the problem ?

 

thanks,

JP

Jos_Woolley's avatar
Jos_Woolley
Icon for Solution Sage rankSolution Sage
5 years ago

Hi JP,

Most likely because you have some rows containing errors prior to the merge. Difficult to be sure without seeing the actual data though, I'm afraid.

Regards

  • jppuam's avatar
    jppuam
    Icon for Helper V rankHelper V
    5 years ago

    Maybe its because of the size ? I'm filterinig 1,8M lines ? 

    The columns dont have any erros, can i do it by DAX ?

     

    thanks,

    JP

    • Jos_Woolley's avatar
      Jos_Woolley
      Icon for Solution Sage rankSolution Sage
      5 years ago

      Sorry, I'm afraid I don't know the answer as to why you're getting that error.

      Regards