Tag: Pivot

The Pivot tag lets you automate the flexYgrid's integrated Pivot Table tool.

<Pivot FilePath="databaseEZ-pivot-setup.xml"/>
XML

Tag Attributes

AttributesAttribute ValuesValue DescriptionComment
TargetApplicable Grid Code

N/A

Not mandatory – If no target is set, this will default to the main grid.
FilePathUser definableThe file path to the previously saved Pivot configuration XML fileMandatory
ServerAbbreviated server names (separated by comma)

N/A

Only applicable in consoleEZ - see detailed description
IndexPositive integerWindow index numberOnly applicable in consoleEZ - see detailed description

Detailed Description

NOTEWhen using the attribute FilePath to retrieve incoming files, it will validate if both the folder path is correct and that the file itself exists.


The configuration for the Pivot Table generator CANNOT be automated directly. The attribute FilePath, along with a saved configuration file must be used.


<Pivot FilePath="databaseEZ-Pivot-setup.xml"/>
XML


NOTEGeneral grid automation actions can be used to configure the resulting pivot table, but these actions MUST be embedded within the Pivot action block.


The Server attribute is only applicable to consoleEZ, in which case it will be mandatory for Target="LogAnalyzer" or Target="VolumeAnalyzer".

The Index attribute is also only used in consoleEZ and is mandatory when using Target="LogAnalyzer" or Target="VolumeAnalyzer", it is the value found on the Log Analyzer and Volume Analyzer windows.


Example Script

<?xml version="1.0" encoding="UTF-8"?>
<ytriaAutomation Application="databaseEZ" ApplicationVersion="16.5">
	<Load Server="ACME01/ACME" Select="True"/>
	<Pivot FilePath="C:\pivot_config.xml">
		<Export>
			<SetParam field="FilePath" value="D:\temp-exports\PivotExport.html"/>
			<SetParam field="ExportType" value="HTML"/>
			<SetParam field="FileOutput" value="Unicode"/>
			<SetParam field="OpenFileOnceGenerated" value="true"/>
		</Export>
	</Pivot>
</ytriaAutomation>
XML


In the script above, the entire server "ACME01/ACME" will be loaded into the database tree in databaseEZ and all databases will be selected and loaded into the main grid. The action 
Pivot will trigger the retrieval of the saved Pivot Table configuration file "pivot_config.xml" and generate a pivot table of the data in the main grid based on this based on this configuration. The resulting table will be exported to an HTML file; the file will open once it has been generated.