Forum Discussion

s15's avatar
s15
Helper III
9 years ago
Solved

Copy two columns to a new table

Hi all,   I have a sample dataset like the one below     What I need is to create a new table then copy Sales and Years column to this table. The purpose is that I will need to pivot Years...
Need Help
  • vanessafvg's avatar
    vanessafvg
    9 years ago

    s15 in power query just  right click table and duplicate and remove columns you dont need

s15's avatar
s15
Helper III
9 years ago

Currently I only have one table named financials. I need a new table names Sales where I need to duplicate data in Sales and Year column from financials table to Sales table.

 

Could you point me to somewhere that I can use Duplicate table. This might be an option then delete uneccessary columns.

 

Thank you very much.

vanessafvg's avatar
vanessafvg
Community Champion
9 years ago

s15 in power query just  right click table and duplicate and remove columns you dont need

  • calerof's avatar
    calerof
    Impactful Individual
    7 years ago

    Hi vanessafvg ,

     

    Question, when you duplicate a table, let's say a dim table, does it get updated every time the original dim table is modified?

     

    Thanks,

     

    Fernando

     

    • RodrigoMachado's avatar
      RodrigoMachado
      Frequent Visitor
      5 years ago

      Hi calerof  yes, when you duplicate a table its source remains the same, so when you edit your database your duplicated table will be edited as well.

      • calerof's avatar
        calerof
        Impactful Individual
        5 years ago

        RodrigoMachado ,

        Thank you for your kind response. Nobody bothered for almost 2 years. 

        Now I got it clearer.

        Cheers,

        Fernando