Skip to main content

Completed

Unpivot

Background

A small script that will take an IDEA file and render it into two columns with one column being the header names and the second column being the data.

Append File Report

Background
This script will generate a report of the files you plan to append together to make sure there are no problems such as fields with the same name and different types.  This will look through all the files before you perform the append and generate a text report that you can review and make any corrections necessary.

Copy Header Info

Background

The script will copy the header info from one file to another file.  This can be used when importing an excel file in which the data is over several tabs but the header info is only on the first tab.  The script will take the header info from the first and copy it to the second file.

The script was updated on March 17, 2016.  It now has an option to copy the old header name to the field description so that information is not lost.