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

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*))