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.