RTF Template: Achieve Distinct Values in RTF Template

Summary:

RTF Template: Achieve Distinct Values in RTF Template

Content (please ensure you mask any confidential information):

Hi Team,

I have an extract where location and some other fields are coming based on employees data. I need to pull only the location details and some other DFF fields in RTF template. I am not pulling employee number and I need distinct values in output based on location. There should not be any duplicate in output. I tried grouping function but it is not filtering out the duplicate values. Can anyone help with the correct syntax to remove duplicates in rtf based on 1 column. Since location id employee's location we are getting duplicates. But since we are not fetching