Forum Discussion
smpa01
2 years agoCommunity Champion
Column Headers
let
// manuallly building src
//contains name of each pq table (opposed to dax derived table)
//starting with a single element for the sample
src={"t1"}, //t1 is the name of a pq table
//need to get the column names
colNames = Table.ColumnNames(src{0}) //errors out
in
colNames
I am trying the above and it is failing. If it can work, I can loop through all table names.
I am aware DAX can get the colNames for all tables in a DB; But I am looking for a PQ solution.
Thank you in advance
let
src={t1},
colname=Table.ColumnNames(src{0})
in colname
2 Replies
- wdx223_DanielCommunity Champion
let
src={t1},
colname=Table.ColumnNames(src{0})
in colname
- lbendlinSuper User
colNames = Table.ColumnNames(src)Also consider using Expression.Evaluate if you have special circumstances.