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 wan...
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

v-cherch-msft's avatar
v-cherch-msft
Icon for Microsoft Employee rankMicrosoft 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
      Icon for Microsoft Employee rankMicrosoft 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

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        Dear Cherie,

         

        Let us consider a sample

         

        Overdue:

        Loanno  amount  overduedate

        1            1000      22-01-2018

        2            550        11-05-2018

        3           2500        12-08-2018

        4            3222       12-08-2018

         

        Preclosure:

        Loanno    Preclosureamount  Preclosuredate

         

        3               2500                       05-08-2018

         

         

        Now i want to exclude the loano 3 in the overdue table as the amount was preclosed.It should work based on the condition where precloseddate=month(TodaysDate)&Year(TodaysDate).