Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Importing Multiple Web Pages with Different Column Names

Hi Everyone! I'm fairly new to the Power Query world, but have been creating my own stock valuation models during the pandemic and thought Power Query could help enhance that hobby. Sorry if I butche...
Need Help
  • Ehren's avatar
    Ehren
    4 years ago

    Hi Mark. You can get the columns positionally using the Table.ColumnNames function. For example:

    // Get the first column name
Table.ColumnNames(MyTable){0}

// Get the second column name
Table.ColumnNames(MyTable){1}
Ehren's avatar
Ehren
Microsoft Employee
4 years ago

Hi Mark. You can get the columns positionally using the Table.ColumnNames function. For example:

// Get the first column name
Table.ColumnNames(MyTable){0}

// Get the second column name
Table.ColumnNames(MyTable){1}