March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
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.
Solved! Go to Solution.
Hi @Anonymous
Try to filter the Preclosure Table first. Then use ‘Left Anti’ between Overdue table and Preclosure table.
Regards,
Cherie
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
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.
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
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).
Hi @Anonymous
Try to filter the Preclosure Table first. Then use ‘Left Anti’ between Overdue table and Preclosure table.
Regards,
Cherie
Dear Cherie,
Where is the Filter Rows option present.
Regards,
Joshua.
Hi @Anonymous
You may find the "Custom Filter" to filter rows.
Regards,
Cherie
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
User | Count |
---|---|
91 | |
90 | |
85 | |
73 | |
49 |
User | Count |
---|---|
167 | |
147 | |
92 | |
70 | |
58 |