#38. Azure Data Factory - Column Patterns in Aggregation to make it simpler

Опубликовано: 15 Октябрь 2024
на канале: All About BI !
6,229
72

We can perform aggregation on the source columns by doing sum()/min()/max(). For doing it, we need to write expressions for as many columns as we want. For instance, if there are 10 columns to do aggregation, we will write 10 expressions. If the number of columns are more or the columns keep changing in the input source, we cant handle it. Column Patterns are something that come as savior for implementing the aggregation on any number of columns in a single expression. This video explains how to use the column pattern to implement aggregation in ADF.