[Smart type resolvers] Table transformation - Githubissues

microsoft / vscode-powerquery

Visual Studio Code extension for Power Query / M.

MIT License

88 stars 16 forks source link

[Smart type resolvers] Table transformation #90

Open JordanBoltonMN opened 3 years ago

JordanBoltonMN commented 3 years ago

A proof-of-concept for smart type resolvers was done using Table.AddColumn. The goal is to implement a resolver for most Table/Record/List functions. This is to track the functions found in the docs.

Remaining

Table.ReplaceKeys
Table.CombineColumns
Table.CombineColumnsToRecord
Table.ExpandListColumn
Table.ExpandRecordColumn
Table.ExpandTableColumn
Table.Group
Table.Keys
Table.ReplaceErrorValues
Table.ReplaceKeys
Table.ReplaceValue
Table.TransformColumns
Table.TransformColumnTypes
Table.TransformRows

Completed

Table.AddColumn

Not planned

Table.AddFuzzyClusterColumn
Table.AddIndexColumn
Table.AddJoinColumn
Table.AddKey
Table.AggregateTableColumn
Table.ConformToPageReader
Table.FillDown
Table.FillUp
Table.FilterWithDataTable
Table.Join
Table.NestedJoin
Table.ReplaceRelationshipIdentity
Table.SplitColumn
Table.Transpose