Forum Discussion

jppuam's avatar
jppuam
Icon for Helper V rankHelper V
4 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
    4 years ago

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

    NewTable =
EXCEPT ( Table1, Table2 )

    Regards

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

Hi,

New query, merge as new:

You can then delete the final column resulting from this query.

If the operation is to consider not just the code_ID column then select all columns as required when performing the merge, for example:

Regards

 

Regards

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

    I was trying to do it with DAX, i'll try it like you said.

    JP

  • jppuam's avatar
    jppuam
    Icon for Helper V rankHelper V
    4 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
      4 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
        4 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