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).
Solved! Go to 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
This worked like magic. Thanks so much!!
User | Count |
---|---|
56 | |
27 | |
25 | |
23 | |
21 |