For more information, please refer to this announcement explaining best practices for getting answers to questions.
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