Element Details: UnCrosstab+Filter
 Back


Available in: Logi Info Source code name: UnCrosstabFilterIntroduced in: v10.1.18

The UnCrosstabFilter element converts one row of multi column data into multiple rows with a single data value each. The element is used to pivot rows of data into columns of data.

Columns identified as LabelColumns are repeated for each new data row created from the pivot operation. To skip a column of data just add the appropriate column name to the RemoveColumns attribute. All other columns will be pivoted into new rows.

Element Group:Organize Data



ATTRIBUTES

Click attribute Name to drill down for more information.

NamePossible ValuesDescription
ColumnHeadingID
UserDefined
(Required) The name of the column containing the pivoted column headings.
ID
UserDefined
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"
LabelColumns
UserDefined
A comma delimited list of the datalayer column names that are not pivoted. As columns of data are converted into rows, the values in these columns are repeated for each new row of data. If left blank, then all columns are pivoted into rows.
RemoveColumns
UserDefined
A comma delimited list of columns to remove from the data.
ValueColumnID
UserDefined
(Required) The name of the new column to contain the data values



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.LDAP
DataLayer.Linked
DataLayer.Mongo Find
DataLayer.Mongo Map Reduce
DataLayer.Mongo Run Command
DataLayer.Plugin
DataLayer.REST
DataLayer.Scheduler
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