Forum Discussion

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