functiontypespowerbimetadatapowerquery
PowerQuery: How to get Column type?
How to get type for specified ColumnName in Table?
Example: How to get type text for column FirstName:
Table code:
= Table.FromRows(
{
{1, "Bob", "Smith", "123-4567"},
{2, "Jim", "Brown", "987-6543"},
{3, "Paul", "Wick", "543-7890"}
},
{"CustomerID", "FirstName", "LastName", "Phone"}
)
P.S. Solution as function strongly appreciated! :)
Related Topics:
Solution
Use combination of Type.TableColumn and Value.Type functions:
Type.TableColumn(Value.Type(TableName),ColumnName)
- How can a function know whether it has been invoked as a constructor (using the `new` keyword)?
- What are the differences between a function expression (`function (…) { … }`) and invoking the Function constructor (`new Function(…)`)?
- Adding functions to Python Shell
- Using IF in function for different queries as a result
- What is it called when a function creates new objects but doesn't use the class keyword, nor "new" keyword (in JavaScript)?
- Initialize a dictionary that stores functions in C#
- Python: ModuleNotFoundError: No module named 'xyz'
- Calculate svymean for variable within user-defined function called by mutate(), across(), with variable name as function parameter
- Any easy way to determine whether functions work on reference or call by value?
- How do I test for exceptions in if-statements in python?
- Python list scope outside a function
- How to calculate the first Monday of the month; python 3.3+
- Function is not working, but gives no error
- Is there any way to list all the views related to a table in the existing postgres schema
- How to check if a function's return value is undefined or not?
- C - function inside struct
- Python weave lists
- Passing an Array as Arguments, not an Array, in PHP
- Excel: Using Index/Match Functions Instead of Vlookup
- Call a function for each row in select - Postgres
- stringdist within a function
- Difference between .Delete and .Clear in Excel VBA?
- Change onClick attribute with javascript
- Datatables Buttons filename prompt function not canceling
- Having issues not including duplicate words randomly populating 3 columns in Excel
- Avoiding NAs in the output of dplyr
- Why is onclick() function calling the function inside instantly?
- Node.js Spawn vs. Execute
- Store query result in a PL/pgSQL variable
- Simplest/cleanest way to implement a singleton in JavaScript