In this video, I demonstrate a simple way to catch duplicate records during input. Check it out:
Tag Archives: Duplicate
Dynamics 365 Business Central: How to find duplicates via AL (Filter for duplicate values)
I was asked an interesting question on LinkedIn yesterday, is there a way to find out duplicates via AL? So in this post I would like to briefly talk about this topic.
First of all, as test data, I use the copy feature on the Item list page to create multiple items with the same Description, and we need to filter for these lines.
D365 Business Central : Duplicate BC Container
I recently have an issue where I need to spin up a new D365BC docker container for the same project. Because I already have some data in my current container, I want to duplicate my existing container (instead of creating a clean new one).
Remove Duplicates and Keep the Last Record with Power Query
Today I was helping a customer with a problem that seemed quite simple on the surface. She had a data table containing historical customer sales orders (each customer has many orders on different dates). The objective was to filter this table in Power Query and just load one record for each customer – the one that was the last order date. To illustrate the problem more clearly, I have adapted the scenario using the Adventure Works database.
Find and Delete Duplicate Photos with Power Query
I was trying to clean up my hard disk drive on my PC the other day. I use a program called WinDirStat to show me graphically what is taking space (as an aside, this is great software and you can download it here). After running the software I noticed that I had stored photos from my phone in a few different places. Each of the 3 sections below are images from my phone stored in different locations.
Avoiding Duplication Of Database Connection Information In Power BI
In a year’s time there will be a great opportunity for someone to present a session on “Power BI Development Best Practices” at the PASS Summit. Before then, we will all have to work out what those best practices actually are – probably the hard way. With that in mind, here’s a suggestion for one good practice that came out of a conversation at this year’s PASS Summit (thank you Prathy).
How to Detect Duplicates
Until Dynamics NAV 2013, the only possibility was to iterate through the table in a loop and then create a sub-loop where another instance of the same table is filtered to check for duplicates.