video1.0<iframe src="https://www.loom.com/embed/83488545b28e44e8a5eeb6cc64d718d2" frameborder="0" width="2214" height="1660" webkitallowfullscreen mozallowfullscreen allowfullscreen></iframe>16602214Loomhttps://www.loom.com16602214https://cdn.loom.com/sessions/thumbnails/83488545b28e44e8a5eeb6cc64d718d2-2110d99055b8c6cb.gif154.222In this video, I’m excited to share a fantastic new feature in ATL that allows for easy distinct string aggregation, which is something Microsoft SQL doesn’t natively support. I demonstrated how this feature simplifies the process of deduplicating values when aggregating data, making it much easier to troubleshoot compared to traditional SQL methods. I walked through the steps of using the deduplicate delimited values transformation in Transformer, showing how it effectively removes duplicates with just a few clicks. I encourage you to explore this feature and see how it can streamline your data handling processes. I hope you find this as helpful as I have!