Forum Discussion
Help me please
Hi everyone,
I need to do the same analysis that I made on a file to another file that has the same source, but different number of culumns and rows.
I have a question for you: Can I import a new dataset and mantein the same changes that I made on the first file?
thank you so much for helping me.
Hi,
The transformations you made with Power Query are coded in M language and they are using the name of the columns.
Knowing that, you'll understand that the number of columns is not so much a subject, but the name of them is. So you need to have the same columns names, to copy paste one code to another project.
Or you'll have to modify the M code to adapt it to your new project 😉
Hope it helps
2 Replies
- AilleryOMemorable Member
Hi,
The transformations you made with Power Query are coded in M language and they are using the name of the columns.
Knowing that, you'll understand that the number of columns is not so much a subject, but the name of them is. So you need to have the same columns names, to copy paste one code to another project.
Or you'll have to modify the M code to adapt it to your new project 😉
Hope it helps
- AnonymousNot applicable
hello,
i think you can try duplicating the table in transform data and then change the navigation and source