Forum Discussion
Power Query Understanding
Peter, no, I mean Source step (very first one), usually that's default name for the first step.
If you click on it in formula bar will be something like
Change file name here and Enter.
If you'd like to combine all files into one table that's what Abiola1 suggested. But even if that's the purpose I'd suggest to play before with queries one by one, just for training purposes.
Peter, the simplest is to duplicate Jan query (right click menu), rename it to Feb one and in Source step in formula bar (or in Advance editor) change name of the queried file.
Thanks for your response.
I have managed to duplicate the Jan query and renamed it to Feb.
When you talk about the source step do you mean the Data Source Settings - see below?
I clicked on that option and changed the source to Feb but the Jan query also changed to Feb file. If I changed the Jan query to the Jan file then the Feb query changes to Jan file as well? Maybe this is not the option that you meant? Help please? Thanks!
Peter, no, I mean Source step (very first one), usually that's default name for the first step.
If you click on it in formula bar will be something like
Change file name here and Enter.
If you'd like to combine all files into one table that's what Abiola1 suggested. But even if that's the purpose I'd suggest to play before with queries one by one, just for training purposes.