• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Blank query based on a Table

Kamo

Member
Hello,

I think this is an easy question for you but I couldn't find the solution.

I have a table "Table1" with a lot of columns (Column1, Column2, Column3.....Column13) and I would like to create a new table with 3 or 4 columns from "Table1"
I know how to do it with "Choose Columns" but I am looking for a more direct way (see Query2).

In "Query1" I tried with =Table1[Column1]
How to add several columns manually for example Column1, Column4, Column8 ?

What is the most effective solution?

Thanks in advance
 

Attachments

  • New Blank query.xlsx
    16.1 KB · Views: 5
Why you want to do that, I've no clue... but do you mean something like below?
Code:
let
    Source = Table.SelectColumns(Excel.CurrentWorkbook(){[Name="Table1"]}[Content],{"Column1", "Column4","Column8"})
in
    Source
 
Hi Chihiro :),

I am trying to learn Power query
I'm testing several ways because I thought I had already seen a simple way to do it

Thank you for this solution
 
Hi GraH - Guido,

As I have never seen any Star Wars movie, I didn't understand at first what this quote means.
With the help of Google I understand better now what Yoda meant :)

I learn to fail, but never fail to learn. ;)

Sincerely
 
Back
Top