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}
jan_tothemoon's avatar
jan_tothemoon
New Member
4 years ago

Hi Mark, 

I've been trying to do something similar to what you´re doing as well but I haven't been sucessfull with M coding, think you could share me your file to grasp an idea to build my report oy maybe we can collaborate together. My goal is to build a complete stock analysis automated.

Regards, 
J.V.