| #shared |
8 |
| #table |
14 |
| @ |
9 |
| Apache Spark |
25 |
| Azure Data Factory |
25 |
| Binary.FromText |
14 |
| Binary.ToText |
11, 14 |
| catch |
7 |
| Combiner.CombineTextByDelimiter |
9 , 19, 20, 22 |
| Combiner.CombineTextByEachDelimiter |
19 |
| Combiner.CombineTextByLengths |
19 |
| Combiner.CombineTextByPositions |
19 |
| Combiner.CombineTextByRanges |
19 |
| Comparer.Equals |
18 |
| Comparer.FromCulture |
17, 18 |
| Comparer.OrdinalIgnoreCase |
17, 18 |
| Comparer.Ordinal |
18 |
| Csv.Document |
2 , 3 , 7 , 23 |
| Culture |
17 |
| Data Activator |
25 |
| Dataflows Gen2 |
25 |
| Date.AddDays |
5 , 15 |
| Date.AddMonths |
15 |
| Date.AddQuarters |
15 |
| Date.AddWeeks |
15 |
| Date.AddYears |
15 |
| Date.Day |
15 |
| Date.EndOfMonth |
15 |
| Date.EndOfWeek |
15 |
| Date.EndOfYear |
15 |
| Date.FromText |
3 , 15 |
| Date.From |
8 , 14, 15 |
| Date.IsInCurrentDay |
15 |
| Date.IsInNextMonth |
15 |
| Date.IsInNextNMonths |
15 |
| Date.Month |
15, 17 |
| Date.StartOfMonth |
15 |
| Date.StartOfWeek |
15 |
| Date.StartOfYear |
15 |
| Date.ToRecord |
15 |
| Date.ToText |
14 |
| Date.Year |
4 , 15 |
| DateTime.FromText |
15 |
| DateTime.ToText |
15 |
| DateTimeZone.UtcNow |
15 |
| Decimal.Type |
22 |
| Delta Lake |
25 |
| Diagnostics.Trace |
24 |
| each |
5 |
| Error.Record |
7 |
| error |
7 |
| Excel.CurrentWorkbook |
2 |
| Excel.Workbook |
2 , 5 , 6 , 10, 23 |
| ExtraValues.Error |
2 |
| ExtraValues.Ignore |
2 |
| ExtraValues.List |
2 |
| File.Contents |
2 , 6 , 23 |
| Folder.Contents |
2 , 5 , 10 |
| Folder.Files |
2 , 5 , 10 |
| Function.InvokeAfter |
11 |
| Grafana |
25 |
| HasError |
7 |
| HDFS (Hadoop Distributed File System) |
25 |
| Html.Table |
11, 12 |
| if ... then ... else |
8 |
| IgnoreCase |
17 |
| IgnoreSpace |
17 |
| Int64.Type |
3 , 22 |
| JoinKind.FullOuter |
16 |
| JoinKind.Inner |
16 |
| JoinKind.LeftAnti |
16 |
| JoinKind.LeftOuter |
16 |
| JoinKind.LeftSemi |
16 |
| JoinKind.RightAnti |
16 |
| JoinKind.RightOuter |
16 |
| JoinKind.RightSemi |
16 |
| Json.Document |
11 |
| KQL (Kusto Query Language) |
25 |
| Kubernetes |
25 |
| let ... in |
8 |
| let |
10 |
| List.Accumulate |
3 , 9 , 19 |
| List.Buffer |
4 |
| List.Combine |
10 |
| List.Count |
3 , 8 , 17 |
| List.Difference |
22 |
| List.Distinct |
20 |
| List.FirstN |
22, 24 |
| List.First |
8 |
| List.Generate |
9 , 11, 24 |
| List.Last |
8 , 9 |
| List.Max |
18 |
| List.Min |
18 |
| List.Numbers |
9 , 24 |
| List.RemoveMatchingItems |
18 |
| List.Select |
8 , 9 , 19, 22 |
| List.Sort |
18 |
| List.Sum |
3 , 8 , 17, 20, 21 |
| List.TransformMany |
9 , 10, 11, 13 |
| List.Transform |
3 , 8 , 9 , 10, 11, 13, 22, 24 |
| List.Zip |
16 |
| MLflow |
25 |
| Number.FromText |
7 , 22 |
| Number.From |
8 , 14 |
| Number.Mod |
17 |
| Number.ToText |
13 |
| OData.Feed |
24 |
| optional |
13 |
| ORC (Optimized Row Columnar) |
25 |
| Parquet |
25 |
| Pdf.Tables |
2 |
| Power BI |
25 |
| Power Query |
25 |
| Prometheus |
25 |
| PySpark |
25 |
| R (SparkR) |
25 |
| Record.Field |
3 |
| Record.FromList |
14 |
| Record.ToTable |
3 , 7 , 7 |
| Replacer.ReplaceText |
1 , 18 |
| Replacer.ReplaceValue |
18 |
| Splitter.SplitByNothing |
19 |
| Splitter.SplitTextByAnyDelimiter |
1 , 2 , 3 , 19 |
| Splitter.SplitTextByCharacterTransition |
19 |
| Splitter.SplitTextByDelimiter |
1 , 2 , 19, 22 |
| Splitter.SplitTextByEachDelimiter |
19 |
| Splitter.SplitTextByLengths |
19 |
| Splitter.SplitTextByPositions |
19 |
| Splitter.SplitTextByRanges |
19 |
| Splitter.SplitTextByRepeatedLengths |
19 |
| Splitter.SplitTextByWhitespace |
19 |
| Sql.Database |
4 |
| SQL |
25 |
| Synapse Analytics |
25 |
| Table.AddColumn |
1 , 2 , 3 , 4 , 5 , 6 , 7 , 7 , 9 , 10, 12, 13, 19, 22 |
| Table.AddFuzzyClusterColumn |
17 |
| Table.AddIndexColumn |
7 |
| Table.Buffer |
4 |
| Table.ColumnNames |
10, 16, 22, 23 |
| Table.CombineColumns |
9 , 19, 20 |
| Table.Combine |
10, 11, 12, 13, 16 |
| Table.Distinct |
22 |
| Table.ExpandListColumn |
3 , 22 |
| Table.ExpandTableColumn |
2 , 3 , 5 , 10, 16, 17, 19, 22, 23, 24 |
| Table.FillDown |
20 |
| Table.FirstN |
17 |
| Table.FromColumns |
14, 19, 24 |
| Table.FromList |
14 |
| Table.FromRecords |
3 , 11, 14 |
| Table.FromRows |
3 , 7 , 8 , 13, 14, 20, 21, 22 |
| Table.FromValue |
14 |
| Table.FuzzyJoin |
16 |
| Table.FuzzyNestedJoin |
16 |
| Table.Group |
3 , 17, 18, 19, 20, 21 |
| Table.Join |
16 |
| Table.Max |
18 |
| Table.Min |
18 |
| Table.NestedJoin |
5 , 16 |
| Table.Partition |
17 |
| Table.Pivot |
2 , 20, 21 |
| Table.PrefixColumns |
16 |
| Table.PromoteHeaders |
3 , 7 , 10, 11, 20 |
| Table.RemoveColumns |
2 , 4 , 5 , 22, 23 |
| Table.RenameColumns |
10, 16, 22, 24 |
| Table.ReorderColumns |
2 , 22 |
| Table.ReplaceValue |
1 , 9 , 10, 18, 19 |
| Table.Schema |
14 |
| Table.SelectColumns |
5 , 10, 16, 22, 23 |
| Table.SelectRows |
2 , 3 , 4 , 6 , 7 , 7 , 10, 24 |
| Table.Sort |
2 , 17, 18 |
| Table.SplitColumn |
1 , 3 , 19, 22 |
| Table.ToList |
19 |
| Table.ToRecords |
13 |
| Table.TransferColumnTypes |
19 |
| Table.TransformColumns |
1 , 5 , 7 , 9 , 14, 19, 22 |
| Table.TransformColumnTypes |
1 , 2 , 3 , 7 , 8 , 8 , 10, 11, 14, 20 |
| Table.TransformRows |
9 |
| Table.UnpivotOtherColumns |
20 |
| Table.Unpivot |
20 |
| Text.AfterDelimiter |
1 |
| Text.BeforeDelimiter |
1 , 5 |
| Text.Clean |
1 |
| Text.Combine |
3 , 13, 19 |
| Text.Contains |
7 , 9 , 18, 22 |
| Text.EndWith |
18 |
| Text.Format |
24 |
| Text.From |
8 , 9 , 14, 22 |
| Text.Length |
9 |
| Text.Lower |
3 , 22 |
| Text.Middle |
3 |
| Text.Remove |
3 |
| Text.Replace |
9 , 12, 22 |
| Text.Reverse |
9 |
| Text.Select |
3 |
| Text.StartWith |
18 |
| Text.Start |
6 |
| Text.ToBinary |
11 |
| Text.Trim |
1 , 3 , 22 |
| Text.Upper |
22 |
| Threshold |
17 |
| TransformationTable |
16, 17 |
| try ... otherwise |
7 , 11 |
| type number, type text, type date, type any |
8 |
| Type.Facets |
14 |
| Type.Is |
3 |
| Type.ReplaceFacets |
14 |
| Value.Compare |
17, 18 |
| Value.Is |
1 , 3 , 7 |
| Value.ReplaceType |
14 |
| Web.BrowserContents |
2 , 11 |
| Web.Contents |
2 , 11, 12, 23 |
| Xml.Document |
2 , 11 |
| Xml.Tables |
2 |
