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

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

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

    Hi Anonymous

     

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

     

     

    Regards,

    Cherie

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Dear Cherie,

       

      Where is the Filter Rows option present.

       

       

      Regards,

      Joshua.

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

        Hi Anonymous

         

        You may find the "Custom Filter" to filter rows.

         

         

        Regards,

        Cherie