Power Query へそのゴマ　INDEX

# Index

|項目|章|
|:-|:-|
#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