Exctracting Cell value from a tables before expanding them

[Anonymous]

this is the list of table where in need to add one more column contains cell value for each table to indicate the name of the company one more for the date of the reportsecond column to contain the name , of course different name based on the value of the cells in the headersthese are the value from each table which i need to bring to new column into the first table.

Hellow guys ,

this is my first question in the form and i wish i could find an ansuwer to it. 

I have to note that iam begginer with M language .

My question is :

I am loading data from a folder which should contain more than 40 identical structured table, now these table arent in a good data set shapte. there is header in contacins comopany name and underneath it with few rows date of the report. the object is to retrive these tow field in put it in new columns right before i expand the tables so these record are attached to each row in each table when become in the same table.

Please refer to above picures for more details. and thanks alot in advance

[ImkeF · Accepted solution]

Hi @Anonymous 

you can add a column with the following code:

[TransformFile][Column2]{1} to retrieve the Company name and 

[TransformFile][Column2]{7} for the date.

See here for more information: http://excel-inside.pro/blog/2015/11/05/absolute-and-relative-references-in-power-query/

[Anonymous]

thanks alot ,,its perfect