Posted inDynamics NAV & BC Tips & tricks
Finding duplicates with AL
In this video, I demonstrate a simple way to catch duplicate records during input. Check it out: Source : Hougaard.com Read more...
Posted inDynamics NAV & BC Tips & tricks
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…
Posted inDynamics NAV & BC Tips & tricks
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). Source :…
Posted inData & Analysis
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…
Posted inData & Analysis
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…
Posted inData & Analysis
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.…
Posted inDynamics NAV & BC Tips & tricks
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. Bron : Ashwini Tripathi Lees meer...