Forum Discussion

Vegas95's avatar
Vegas95
Regular Visitor
3 years ago
Solved

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

  • AilleryO's avatar
    AilleryO
    Memorable 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

  • Anonymous's avatar
    Anonymous
    Not applicable

    hello,
    i think you can try duplicating the table in transform data and then change the navigation and source