Element Details: Remove+Columns
 Back


Available in: Logi Info Source code name: RemoveColumns

The RemoveColumns can be used to reduce the size of the data during processing. If a column is no longer required, you can use this element to delete it. Any removed columns and their data are no longer available for additional processing.

RemoveColumnsType attribute is used to determine if the names are of columns to drop or keep.

RemoveColumnsType defaults to "Drop". So any columns added to ColumnNames will be deleted.

Element Group:Add and Replace Columns



ATTRIBUTES

Click attribute Name to drill down for more information.

NamePossible ValuesDescription
ColumnNames
UserDefined
(Required) A list of column names, separated by commas. For example: OrderID, CustomerID, EmployeeID, OrderDate
ID
UserDefined
(Required) The ID attribute is a pervasive attribute that uniquely identifies an element within a definition file. The ID needs to be a unique value within the definition.
IncludeCondition
True
False
An expression that evaluates to a value of True or False. If the expression is blank, or evaluates to true the element is processed. If the expression evaluates to false, the element is skipped. Expressions should be in VBScript or JavaScript syntax. For .NET versions, the scripting language can be set in the _settings.lgx General element. For Java versions, the scripting language is always JavaScript. Typically, you would compare values using an operator, such as "@Session.value~ < 0". Use quotes when working with strings: "@Session.myValue~" == "SomeValue"
RemoveColumnsType
Keep
Drop
This attribute is used to determine if the values in the ColumnNames attribute are of columns to drop or keep. "Drop" will delete the columns listed in the ColumnNames attribute. (Default) "Keep" will copy only the columns listed in the ColumnNames attribute. All other columns will be removed from the data stream.



PARENT ELEMENTS

Click element to drill down for more information.

DataLayer.Bookmarks
DataLayer.Cached
DataLayer.CSV
DataLayer.Definition List
DataLayer.Directory
DataLayer.ETL
DataLayer.Excel
DataLayer.Fixed Format File
DataLayer.Google App
DataLayer.Google Spreadsheet
DataLayer.JSON
DataLayer.Linked
DataLayer.Mongo Find
DataLayer.Mongo Map Reduce
DataLayer.Plugin
DataLayer.REST
DataLayer.SimpleDB
DataLayer.SP
DataLayer.SQL
DataLayer.Static
DataLayer.Twitter
DataLayer.Web Feed
DataLayer.Web Scraper
DataLayer.Web Service
DataLayer.XML


CHILD ELEMENTS

Click element to drill down for more information.



 Back to top


 Chart Debug