REMOVE COLUMNS

Overview

Removes the columns that found, or not found, in the comma-separated list of columns provided. The list of columns is case-insensitive and may include square brackets if desired. If columns are not found, no error or warning is thrown.

Syntax

Removes the columns specified in the list or removes the columns not found in the list provided when the NOT option is used.

REMOVE COLUMNS 
	{ NOT } IN (<field>,...)
;

COLUMNS	Comma-separated list of columns to operate on; you can use square brackets if needed (ex: [first field], secondField)
NOT	Changes the operation from an inclusive to an exclusive operation

Example 1

-- Get data from an RSS Feed
SELECT * FROM HTTP [Rss Feed] (GET /econi.xml) APPLY TX (//item);

REMOVE COLUMNS IN (isPermaLink);