About EasyMorph Tutorials & Examples Web-help

Unpivot without selection


#1

Unpivot should be possible without selecting anything. This is useful way to convert a file of column headers into rows for use with Rename Columns with Lookup

Workaround are:

Option 1: Add RowNo, then unpivot except for Row No
Option 2: Select all columns, apply, unselect all columns, apply


#2

Hi Joe,

In the latest version (3.5.0.3) it is possible to unpivot without checking anything. What version are you using?

PS. The canonical way of obtaining a list of column names is Keep 1 top row, then Unpivot without checking anything.


#3

Ah, 3.5.0.2. Maybe that's why. I will download 3.5.0.3


#4

Edit: It actually does work (maybe it did in 3.5.0.2) as well, but I was expecting the "Apply" button to be available

Nope, still an 'issue' in 3.5.0.3. See screenshot

This the first step to import a file with just the column headings


#5

I see your point. Yes, it's a bug.

Looping in @vitaly.