Forum Discussion
Exctracting Cell value from a tables before expanding them
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 da...
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/
ImkeF
Community Champion
Community ChampionHi 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/
thanks alot ,,its perfect