Delete Duplicate Records in SQL table transformer in confluence

[Dhiraj Kr_ Gupta]

There are different records in SQL Table Transformer, but among them there are many duplicate records.So I want to delete duplicate so that only unique records remains

For eg

Input ( 4 Records)

Name Age City

John 26 London

Snow 27 New York

John 26 London

Snow 27 New York

Output (2 Records)

Name Age City

John 26 London

Snow 27 New York

[Stiltsoft support · Accepted solution]

Hi @Dhiraj Kr_ Gupta ,

The following query should be working fine for you:

SELECT 'Name', 'Age', 'City'
FROM
(SELECT
DISTINCT('Full String'),
*
FROM
(SELECT 'Name' + 'Age' + 'City' AS 'Full String',
*
FROM T*))

[Dhiraj Kr_ Gupta]

Thank You Very Much