How to create a new table of an existing table?

[Anonymous]

Hello, I have the following problem. My table looks like this:

I want to sum all the entries of the column "total secounds" with the same value in "Kalenderwoche copy". The different sum should be saved in a new table. Does someone know how to do this?

Thank you very much!

[tackytechtom · Accepted solution]

Hi @Anonymous ,

Do you mean something like this:

Mockup "Source":

Mockup Solution as new Table

Here is how I did it:

1) Right Click in the Query area > New Query > Blank Query:

2) write your table name into the bar

3) Select the Kalenderwoche - Copy column and choose Group By. Fill in the boxes accordingly:

Does this solve your issue? 🙂

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/

[Anonymous]

Thank you for your response. @tackytechtom  My table is called "Abzug KW". Unfortunately, I get an error meassage when I type it in the bar: = Abzug KW

I think, the error is because of the space in the name of the table. Do you know how to fix that?

[tackytechtom]

Hi @Anonymous ,

You should be able to use the syntax as #"Abzug KW"  to refer to the table. Alternatively, you can right click on the table Abzug KW in the query pane and then press "Duplicate" as @mussaenda  suggested 🙂

Please, let me know if this helps!

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/

[mussaenda]

Hi @Anonymous ,

Try using reference instead of starting from blank query.

Right click the table you want to refer. 

Then you can follow the steps he showed you.

Hop this helps.

Thanks