Forum Discussion

Bamak's avatar
Bamak
Helper V
5 years ago
Solved

Query M - Merge 2 Big Query tables - Lef join issue

Hi, I'm trying to merge 2 bigquery tables in query M  via Left outer , but i'm facing a strange issue  Info :  If inner join , there is no problem   Exception: ExceptionType: Microsoft.Mashup...
Need Help
  • Bamak's avatar
    Bamak
    5 years ago

    Hi

    apparently the columns used in left join must be in REQUIRED mode
    The query folding will be more refined, without OR conditions in the ON

  • Bamak's avatar
    Bamak
    Helper V
    5 years ago

    Hi Amit

     

    Query is generated 100% by Desktop (query M)

    4 steps only

    Issue on a "simple" merge  left join

     

    Thanks a lots for informations

     

     

    • Bamak's avatar
      Bamak
      Helper V
      5 years ago

      Hi

      apparently the columns used in left join must be in REQUIRED mode
      The query folding will be more refined, without OR conditions in the ON