Loading table based on condition

[Anonymous]

Dear all,

Good Morning!

I have two tables Overdue and Preclosure.

Overdue:

Loanno

Overdueamount

EMI

OverdueDate

Preclosure:

Loanno

PreclosureDate

Now in Overdue table  i want only the Loanno  which not exists in Preclosue table for current month and year.

Regards,

Joshua.

[v-cherch-msft]

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]

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]

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]

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 · Accepted solution]

Hi @Anonymous

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

Regards,

Cherie

[Anonymous]

Dear Cherie,

Where is the Filter Rows option present.

Regards,

Joshua.

[v-cherch-msft]

Hi @Anonymous

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

Regards,

Cherie