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 Report view is also in Query Editor?

 

Thanks in advance

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

11 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    8 years ago

    In Query Editor, right-click the columns that you do not want and remove them.

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi Ehab,

     

    1. When you enter the query editor just select the column you want to delete (like in my picture below)

    2. You can also select all columns you want to keep and press remove other columns (you can select multiple by holding CTRL)

     

     

    When you delete it in query editor it will also be deleted from the report view.

     

    Regards,

     

    L.Meijdam

     

    • 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

       

       

      • MFelix's avatar
        MFelix
        Icon for Super User rankSuper User
        8 years ago

        Hi Ehab,

         

        On  the query editor if you do CTRL + click on the columns you want and the DELETE on the keyboard it will do all columns at once.

         

         

        Regards,

        MFelix

  • 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