Forum Discussion
how do you remove columns in query editor
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
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
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
- Greg_Deckler
Community Champion
You can also hold down Shift or maybe Ctrl key to select the columns you want and then right click and remove other columns.
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
