We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Final output - removing dupllicate values from 1st few columns for cleaner representation

amitshk
5 - Atom

Hi,

I have 2 tables joined in my final output (join on 1st 2 columns - portfolio_code and int_instr_ref).

 

Values from my 1st table are in 1st 5 columns. But against each line from this table, there could be more than 1 row in the 2nd table

As such, values in 1st 5 columns look duplicate, when the corresponding multiple rows from 2nd table are put adjacent to it.

 

How can we clear any duplicate values from 1st 5 columns, while still retaining corresponding multiple rows from sixth Column onwards?

 

I have attached my input sample and expected output sample (but if there is a better way to represent the output, that is welcome as well).

2 REPLIES 2
fmvizcaino
17 - Castor
17 - Castor

Hi @amitshk ,

 

Here is a suggestion by using both multi tools from preparation category. First multi-row to identify all duplicated lines and the multi-field to erase the data.

fmvizcaino_0-1599800181560.png

 

 

Best,

Fernando Vizcaino

amitshk
5 - Atom

This worked like magic. Thanks so much!!

Labels
Top Solution Authors