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 guys. i was hoping for a bird's eye view like in the report view with checkboxes of all the columns - as i said, if it's 30+ columns, the scrolling and deleting one-by-one (even with SHIFT & CTRL shortcuts to delete in groups) is cumbersome ...  but sounds like it doesn't exist. 

 

Appreciate the prompt responses.

 

 

v-jiascu-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft Employee
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 for this!

     

    and thank you everybody