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

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
Icon for Microsoft Employee rankMicrosoft 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
      Icon for Microsoft Employee rankMicrosoft Employee
      8 years ago

      Hi Anonymous

       

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

       

       

      Regards,

      Cherie