Data table transformations

The following items are a collection of data table transformation code examples.

1. Pivot
   1. https://community.tibco.com/wiki/how-add-data-table-pivot-transformation-using-ironpython-tibco-spotfire
2. Unpivot
   1. See post by rgablejr: https://community.tibco.com/questions/how-create-unpivotted-table-iron-python
3. Insert columns
   1. https://community.tibco.com/wiki/how-insert-columns-existing-data-table-custom-column-match-tibco-spotfirer-using-ironpython
4. Insert rows
   1. https://community.tibco.com/wiki/how-append-new-rows-existing-data-table-tibco-spotfirer-using-ironpython-scripting
5. Change column names
   1. https://www.gmrinsight.com/managing-data/rename-data-table-column
6. Change data types
   1. See the "fixed" portion of william.campoli's 2nd post: https://community.tibco.com/questions/spotfire-change-datatype-column-datatable-ironpython
7. Data function
   1. https://www.cambridgesoft.com/support/EnterpriseSupport/KnowledgeBase/FAQ/details/Default.aspx?TechNote=3118
8. Exclude columns
   1. https://www.gmrinsight.com/managing-data/remove-data-table-column

Other useful examples

1. Add columns dynamically
   1. http://spotfired.blogspot.com/2014/04/add-columns-dynamically-to-data-table.html
2. Add in rows for missing data
   1. https://community.tibco.com/wiki/ironpython-script-add-rows-zero
   2. The conversation can be found here: https://community.tibco.com/questions/show-missing-data-0-and-line-drop-line-chart#node-686301