Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Loading table based on condition

Dear all,

 

Good Morning!

 

I have two tables Overdue and Preclosure.

 

Overdue:

Loanno

Overdueamount

EMI

OverdueDate

 

Preclosure:

Loanno

PreclosureDate

 

Now in Overdue table  i want only the Loanno  which not exists in Preclosue table for current month and year.

 

 

Regards,

Joshua.

 

Need Help
  • v-cherch-msft's avatar
    v-cherch-msft
    8 years ago

    Hi Anonymous

     

    Try to filter the Preclosure Table first. Then use ‘Left Anti’  between Overdue table and Preclosure table.

     

     

    Regards,

    Cherie

7 Replies

  • v-cherch-msft's avatar
    v-cherch-msft
    Microsoft Employee
    8 years ago

    Hi Anonymous

     

    You may try to use ‘Merge Queries’ with ‘Left Anti’ in Query Editor. Then you may filter the date with ‘Date Filters’ as below.

     

    Regards,

    Cherie

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Dear Cherie,

       

      Thanks for ur reply.Will Left Anti (rows only in first) will show the data of overdue table for only loanno that not exists in preclosure table?

       

       

      Regards,

      Joshua.

      • v-cherch-msft's avatar
        v-cherch-msft
        Microsoft Employee
        8 years ago

        Hi Anonymous

         

        The data will be shown as below picture. If it is not your case, please share some data sample and expected output.

         

        Regards,

        Cherie