Difference between revisions of "Drop Column Node"
(→Drop Column) |
|||
Line 5: | Line 5: | ||
http://www.international-presence.com/wikidocs/images/drop_column_dialog.png | http://www.international-presence.com/wikidocs/images/drop_column_dialog.png | ||
− | Type in the name of the column you wish to drop as is - i.e. do not use the :var{...} convention. | + | |
+ | Type in the name of the column you wish to drop as is - i.e. do not use the :var{...} convention. However you can still use ctrl+space to bring up suggestions. | ||
+ | |||
+ | === Example === | ||
+ | |||
+ | The following Task creates a Data Table then outputs it as HTML. A Drop Column node is then inserted to remove the TELEPHONE_NUMBER column (maybe we don't want this to be public!) and then the table is outputted again. | ||
+ | |||
+ | http://www.international-presence.com/wikidocs/images/drop_column_task.png | ||
+ | |||
+ | Here is the HTML output before the Drop Column Node: | ||
+ | |||
+ | And here it is after the Drop Column Node: | ||
+ | |||
+ | |||
{{DataTableNodes}} | {{DataTableNodes}} |
Revision as of 14:44, 20 January 2011
Drop Column
This Node drops individual columns from the current Data Table. Dragging a Drop Column node into your Task will present the following dialog box:
http://www.international-presence.com/wikidocs/images/drop_column_dialog.png
Type in the name of the column you wish to drop as is - i.e. do not use the :var{...} convention. However you can still use ctrl+space to bring up suggestions.
Example
The following Task creates a Data Table then outputs it as HTML. A Drop Column node is then inserted to remove the TELEPHONE_NUMBER column (maybe we don't want this to be public!) and then the table is outputted again.
http://www.international-presence.com/wikidocs/images/drop_column_task.png
Here is the HTML output before the Drop Column Node:
And here it is after the Drop Column Node:
Data Filter | Require Columns | Append Data Column | Multiple Column Appender
Drop Column | Drop Row(s) | Calculate Column Aggregate | Dataset Splitter | Merge Data
Create Data Table | Clear Data Table | Sort Data Table | Drop Duplicate Rows | Store Data Table | Retrieve Data Table
Task Elements > Data Table Nodes > Drop Column Node