Blank query based on a Table

[Kamo]

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

 

[Chihiro]

Why you want to do that, I've no clue... but do you mean something like below?

let
    Source = Table.SelectColumns(Excel.CurrentWorkbook(){[Name="Table1"]}[Content],{"Column1", "Column4","Column8"})
in
    Source

 

[Kamo]

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

 

[GraH - Guido]

A wise creature once said:

No! Try not. Do, or do not. There is no try.

 

[Kamo]

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