UNPIVOT_INFO

Used by EE_UNPIVOT message.

typedef struct _UNPIVOT_INFO {
	UINT cbSize;
	UINT nFlags;
	LPCWSTR pszSelect;
	LPCWSTR pszAttrLabel;
	LPCWSTR pszValueLabel;
	int nFooter;
} UNPIVOT_INFO;

Fields

cbSize

Specifies sizeof( UNPIVOT_INFO ).

nFlags

Not used. Must be 0.

pszSelect

Specifies the string to select which columns to be unpivot. Examples are "2-5", "3-", "1,3,5". This field cannot be empty.

pszAttrLabel

Specifies the heading label for the attribute column to be created.

pszValueLabel

Specifies the heading label for the value column to be created.

nFooter

Specifies the number of rows in the footer. The footer rows area not converted.

Version

Supported on Version 21.4 or later.