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,

 

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