Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Bring in custom column in new query

Hi Community,

 

I'm stuck and am a newbie to Power Query. I've been digging in the WWW, but to no avail so hoping I can pick your brains.

 

In table A, I have added a custom column with an if statement, the column header is called Amounts as well as the applied step. I have created a 'new blank query' and am trying to bring in various columns from table A with including the custom column, by using the below query

 

#"table A"[[Date],[Name],[custom column]] this errors out when trying to bring in the custom column, however if I remove the custom #"table A"[[Date],[Name]] it brings the called columns.

 

The Amounts column is value format, there are no errors or null values in that column, reference to column header text is exact. 

 

Really appreciate your help, Thanks

 

 

4 Replies

  • dufoq3's avatar
    dufoq3
    Community Champion
    2 years ago

    Hi, it should work. In new query you can just refer to table a so Source = #"table A" and then select columns you want, right click and REMOVE OTHER COLUMNS or you can try 

    Source = Table.SelectColumns(#"table A", {"Date","Name", "custom column"})
  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Thank you for coming back Dufoq3, still doesn't work. My error says the column doesn't exist strangely. However, I just cloned the table and deleted the rest of the columns

    • dufoq3's avatar
      dufoq3
      Community Champion
      2 years ago

      Power Query is case sensitive so be careful because "table A" <> "Table A" and "custom column" <> "Custom Column" etc...

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hi,

      Thanks for the solution dufoq3  provided, and i want to offer some more information for user to refer to.

      hello Anonymous  you can try the following code.

      let
    a = Table.SelectColumns(#"table A",{"Date","Name", "Amounts"})
in
    a

       

       

      Best Regards!

      Yolo Zhu

      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.