cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
KL718 Frequent Visitor
Frequent Visitor

How to edit New Table in edit query

I have table with (30K ROws, 30 Columns). I need 3 columns & all rows. I used New Table option with summarize option. Now I cannot edit it iin edit query.

 

What is the workaround. 

 

Current Data

Name  Code

X          [123,234]

r           [32,34]

 

If I used original table I can go into edit query & use split option, replace option & then unpivot to get below result. But If I create NEW table it does not allow to edit it.

output required

Name  Code

X         123

X         234

r          32

r  34

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: How to edit New Table in edit query

@KL718 

 

Calculated tables created with DAX are not visible in the Query Editor. You may Reference queries in the Query Editor and change code in The Advanced Editor.

let
    Source = Table1,
    #"Removed Other Columns" = Table.SelectColumns(Source,{"Column1", "Column2"}),
    #"Removed Duplicates" = Table.Distinct(#"Removed Other Columns")
in
    #"Removed Duplicates"
Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
AClerk New Contributor
New Contributor

Re: How to edit New Table in edit query

Hey @KL718 

What is the source?
Is it SQL?
Why not query with relvant data only?

select col1, col2, colN from Table

 

Cheers!
A

KL718 Frequent Visitor
Frequent Visitor

Re: How to edit New Table in edit query

Source is Excel file. I do not want to use original file since the output what i want will be moved from column to row level thus creating duplication for all 30 K rows & 30 columns which I do not want.

 

I just want to subset the data & oull only 3 columns & work on it.

Community Support Team
Community Support Team

Re: How to edit New Table in edit query

@KL718 

 

Calculated tables created with DAX are not visible in the Query Editor. You may Reference queries in the Query Editor and change code in The Advanced Editor.

let
    Source = Table1,
    #"Removed Other Columns" = Table.SelectColumns(Source,{"Column1", "Column2"}),
    #"Removed Duplicates" = Table.Distinct(#"Removed Other Columns")
in
    #"Removed Duplicates"
Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Ask Amanda Anything Q&A

Ask Amanda Anything Q&A

Learn the answers to some of the questions asked during the Amanda Triple A event.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Users Online
Currently online: 151 members 1,930 guests
Please welcome our newest community members: