cyfairmedicalpa
8 years agoNew Member
Status:
Needs Votes
Include MissingField Argument with Table.TransformColumnTypes Function for Power Query
From what I can see (and it's not listed in the M function reference) the built in Table.TransformColumnTypes doesn't accept the MissingField argument like most of the other Table functions. This is ...
rick1
3 years agoNew Member
Thanks greg, I love that idea. Currently the MissingField function are only used for:
- Record.RemoveFields
- Record.RenameFields
- Record.ReorderFields
- Record.SelectFields
- Record.TransformFields
- Table.FromRecords
- Table.RemoveColumns
- Table.RenameColumns
- Table.ReorderColumns
- Table.SelectColumns
- Table.TransformColumns
Sounds great to add Table.TransformColumnTypes to it.
If at any time you're curious where numeration are used, I think you'll find this page useful: https://powerquery.how/missingfield-error/
Recent ideas
OneLake Catalog full-text and content search
Why is it not possible to search OneLake by item description or even content? So I was thinking about how a user can find a table if they don't know in which lakehouse it is located? Why can't you se...TePe8 hours agoHelper IVPlanned1.1KViews21likes5Comments