Skip to main content

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.

Documentation

This script will take an IDEA file and render it into a two column file.  As an example, this file as four columns and three rows.  The script will take the header names and put them in column 1 and the data into column 2.

Image
Unpivot1

The following is the dialog, in this dialog you need to select the IDEA file to be transformed, enter the two column names and give an output filename.

Image
Unpivot Dialog

The following will be the result.

Image
Unpivot2

It is recommended that it be added to the IDEAScript.com ribbon under the IS Categorize grouping.

Language
IDEAScript