{"type":"video","version":"1.0","html":"<iframe src=\"https://www.loom.com/embed/83488545b28e44e8a5eeb6cc64d718d2\" frameborder=\"0\" width=\"2214\" height=\"1660\" webkitallowfullscreen mozallowfullscreen allowfullscreen></iframe>","height":1660,"width":2214,"provider_name":"Loom","provider_url":"https://www.loom.com","thumbnail_height":1660,"thumbnail_width":2214,"thumbnail_url":"https://cdn.loom.com/sessions/thumbnails/83488545b28e44e8a5eeb6cc64d718d2-2110d99055b8c6cb.gif","duration":154.222,"title":"34 - Simplifying Distinct String Aggregation in AETL with Ease! 🎉","description":"In 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!"}