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

 

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