Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

removing duplicate rows and keeping first row of data

Tid14
8 - Asteroid

Tid14_0-1732624620146.jpeg

 

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.

Tid14_1-1732624620133.jpeg

 

 

Any help on this please?

Thanks in Advance

 

5 REPLIES 5
shancmiralles
11 - Bolide

hi @Tid14 

 

screenshots/ attachments are too small to read. 

Manomallik236
6 - Meteoroid

hi @Tid14 

please share your attachments again as its not clearly visible.

Tid14
8 - Asteroid

Input 

 

 

Tid14
8 - Asteroid

Output

Labels
Top Solution Authors