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

[amitshk]

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).

[fmvizcaino · Accepted solution]

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.

Best,

Fernando Vizcaino

[amitshk]

This worked like magic. Thanks so much!!