Forum Discussion

Ehab's avatar
Ehab
Regular Visitor
8 years ago
Solved

how do you remove columns in query editor

I imported an excel sheet with many columns   it's easy to select the columns i want in Report view, but in Query Editor  it shows all of them. how can they be in sync so whatever columns i see in ...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    8 years ago

    Hi Ehab,

     

    1. If you want to delete some columns, you can also do it in the Data or Report pane.

    2. There is a view of all the columns in the Query Editor. 

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    Best Regards!

    Dale

Ehab's avatar
Ehab
Regular Visitor
8 years ago

thanks, 

 

i was just wondering if there was an easy view as in the report menu  shown below ... when you have 30+ columns and you only want a handful, the approach you mention is very time consuming (apologies on the screen shot ... blocked out much of it below for confidentiality reasons ... there are 30+ fields ... being able to scroll quickly and check the ones i want is very convenient

 

 

poifish's avatar
poifish
New Member
8 years ago

I don't know if you still need to know a way to easily select the columns you want but next to <Remove Columns> there is <Choose Columns> which allows you to selct the columns you would like to keep shown in a list format