DEV Community

Cover image for #104 — Deduplication of Row-Based Data — by Whole Row — Keeping the Original Order
Judith-Data-Processing-Hacks
Judith-Data-Processing-Hacks

Posted on

2 1 1 1 1

#104 — Deduplication of Row-Based Data — by Whole Row — Keeping the Original Order

#programming #beginners #tutorial #productivity

Problem description & analysis:

There is a data table:
source table

Task: Find out the whole-row data that are not duplicate, and the first duplicate whole-row data.

Solution:

Use SPL XLL and enter the following formula:
=spl("=E(?1).group@u(ID,Name,Gender,Birthday).(~(1))",A1:D7)

The results are shown below:

result table

Download esProc Desktop for FREE and add this powerful technique to your data toolkit!! 🚀🔥⬇️

✨SPL download address: esProc Desktop FREE Download

✨Plugin Installation Method: SPL XLL Installation and Configuration

✨References to other rich Excel operation cases: Desktop and Excel Data Processing Cases

✨YouTube FREE courses: SPL Programming

profile
Sentry
 Promoted

Sentry image

Hands-on debugging session: instrument, monitor, and fix

Join Lazar for a hands-on session where you’ll build it, break it, debug it, and fix it. You’ll set up Sentry, track errors, use Session Replay and Tracing, and leverage some good ol’ AI to find and fix issues fast.

RSVP here →

Top comments (1)

Collapse
 
judith677 profile image
Judith-Data-Processing-Hacks •

Explore new tools and expand your perspective with the communities!

🌟Discord
🌟Reddit

profile
Sentry
 Promoted

nextjs tutorial video

Youtube Tutorial Series

So you built a Next.js app, but you need a clear view of the entire operation flow to be able to identify performance bottlenecks before you launch. But how do you get started? Get the essentials on tracing for Next.js from @nikolovlazar in this video series 👀

Watch the Youtube series

Read next

mikeyoung44 profile image

Revolutionary Two-Layer Framework Makes Agent-Based Models More Realistic and Adaptive

Mike Young -

luca1iu profile image

SQL Recursive Queries - Understanding Common Table Expressions (CTEs)

Luca Liu -

ianbrumby profile image

Finally got some time to play with the new JSONata and Variables support for Step Functions, and I have to say, it is massive improvement. Check out my latest blog post, where I walk through a simple example of how easy it is to handle pagination now

Ian -

devvemeka profile image

Salesforce vs. HubSpot: Which CRM is Right for Your Team?

DevvEmeka -