Name is required.
Email address is required.
Invalid email address
Answer is required.
Exceeding max length of 5KB

To identify the duplicates on key column

Hi,

I have to compare the current record key column value with previous record key column value in same tale (comparison on same column). If duplicate found, i have to concatinate other column values.

Exp:

Input:

Id(key), Code
1, A
1, B

Output:

Id, Code
1, A|B

Please help me on this requirement.

Regards,
Mallikarjuna P

2 Community Answers

Best Answer  >Matillion Agent  

Paul Johnson —

Hi Mallikarjuna,

You can also use the transpose rows component to achieve this – I have attached another example for you.

Matillion Agent  

Paul Johnson —

Hi Mallikarjuna,

You can achieve this by using either the Calculator component or the SQL component and making use of the Redshift LISTAGG window function.

I have attached an example job for you – if you have any problems with the attachment I can email it to you.


Best Answer  Matillion Agent  

Paul Johnson —

Hi Mallikarjuna,

You can also use the transpose rows component to achieve this – I have attached another example for you.

Post Your Community Answer

To add an answer please login