Forum Discussion
"Key didn't match any rows" error message while trying to combine & edit files form Folder
Hi I'm trying to set up a demo of a Power Query to merge data from 3 multi-worksheet files. Each of these files has 2 worksheets, "RedStreet" and "GreenStreet", containing some simp...
you're welcome :smileyhappy:
Did I answer your question? Mark my post as a solution!
Proud to be a Datanaut!
Stachu
Community Champion
Community ChampionI can combine the files without any problem as long as I use the sheet name (same for all the files) and not the table name (different per year)
so for GreenStreet the M code in the 'Transform Sample File from ...', in the advanced editor should look like this
let
Source = Excel.Workbook(#"Sample File Parameter1", null, true),
GreenStreet_Sheet = Source{[Item="GreenStreet",Kind="Sheet"]}[Data],
#"Promoted Headers" = Table.PromoteHeaders(GreenStreet_Sheet, [PromoteAllScalars=true])
in
#"Promoted Headers"
Thank you Stachu!
- Stachu
you're welcome :smileyhappy:
Did I answer your question? Mark my post as a solution!
Proud to be a Datanaut!