topic Re: removing duplicate rows and keeping first row of data in Alteryx Designer Desktop Discussions

removing duplicate rows and keeping first row of data

Tid14 — Tue, 26 Nov 2024 12:37:45 GMT

Hi, I am working on a workflow where I am using the above attached input, In the given data first 7 columns are same and then from purchase to Surplus it differs.

I want output wherein the duplicate

data having same rows in first seven columns gets removed and it shows up only first row and then in the last surplus amount column the amount in the first row shows up as 9265.62 and then in the remaining 6 rows having the same amount it covert into zero as i am attaching in the image of output i want to get.

Any help on this please?

Thanks in Advance

Re: removing duplicate rows and keeping first row of data

shancmiralles — Tue, 26 Nov 2024 13:23:20 GMT

hi @Tid14

screenshots/ attachments are too small to read.

Re: removing duplicate rows and keeping first row of data

Manomallik236 — Tue, 26 Nov 2024 13:30:11 GMT

hi @Tid14

please share your attachments again as its not clearly visible.

Re: removing duplicate rows and keeping first row of data

shancmiralles — Tue, 26 Nov 2024 14:04:56 GMT

Duplicate post:
https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/removing-duplicate-rows-and-converting-duplicate-amount-into/td-p/1344022

Re: removing duplicate rows and keeping first row of data

Tid14 — Tue, 26 Nov 2024 14:35:55 GMT

Input

Re: removing duplicate rows and keeping first row of data

Tid14 — Tue, 26 Nov 2024 14:39:53 GMT

Output