Using REGEXP_REPLACE in my query

quad4x — Sat, 16 Nov 2024 03:03:38 GMT

- Talend Open Studio for Big Data 6.5.1

I have a query pulling data and one of the columns is a list of remedy tickets. In my query, I'm using a regex to remove duplicates returned by the listagg.

select distinct rt.change_request_name,rt.change_request_number,rt.user_id,rt.full_name,
rt.termination_date,
RTRIM (
REGEXP_REPLACE (
(listagg(ica.ticket_number,',
') within group (ORDER BY ica.ticket_number) over (partition by ica.change_request_id)),
'([^,]*)(,\1)+($|,)',
'\1\3'),',')
as Remedy_Ticket from remedy_ticket rt

When I run my query in SQL Developer the results return as expected with the duplicates removed.

When it is part of my job, the results still contain the duplicates.

Re: Using REGEXP_REPLACE in my query

manodwhb — Sat, 07 Mar 2020 10:03:21 GMT

@quad4x , create a metadata for that db in repository and when you try to run this query against to this is it showing duplicates?

topic Using REGEXP_REPLACE in my query in Talend Studio

Using REGEXP_REPLACE in my query

Re: Using REGEXP_REPLACE in my query