Explode Multivalues

Tag: ExplodeMultivalues

The ExplodeMultivalues function expands (or explodes) multivalues in the grid.

<ExplodeMultivalues/>

XML

Tag Attributes

Attributes	Attribute Values	Value Description	Comment
Target	M/A	Identifies the grid by name Do not use "grid" for main grid. No target is necessary in sapio365	N/A
ColumnID	N/A	The list of column UIDs separated by a semi-colon that shows the columns if they're not visible.	Mandatory

Example Script

<ytriaAutomation Application="sapio365">
	<ShowMyDataMail>
		<Select Lines="ByValue">
			<SetParam ColumnID="senderName" Value="Alex Wilber"/>
		</Select>
		<!--SelectColumn ColumnID="toRecipientsAddresses"/-->
		<ExplodeMultivalues ColumnID="toRecipientsAddresses"/>
		<ExplodeDates ColumnID="receivedDateTime"/>
		<ExplodeTimes/>
		<Export>
			<SetParam Field="FileOutput" Value="ASCII"/>
			<SetParam Field="Mode" Value="Create"/>
			<SetParam Field="ExportType" Value="HTML"/>
			<SetParam Field="ChildrenOnly" Value="False"/>
			<SetParam Field="ExpandAllGroups" Value="False"/>
			<SetParam Field="OpenFileOnceGenerated" Value="True"/>
			<SetParam Field="SelectedRowsOnly" Value="True"/>
			<SetParam Field="ExcelSheetName" Value=""/>
			<SetParam Field="ExcelTemplate" Value=""/>
			<SetParam Field="FilePath" Value="AlexWilberMails-Exploded"/>
		</Export>
		<ImplodeAllDateTimes/>
		<ImplodeAllMultivalues/>
	</ShowMyDataMail>
</ytriaAutomation>

XML

With several columns.

<ytriaAutomation Application="sapio365">
	<Select Lines="All"/>
	<ExplodeMultivalues ColumnID="assignedLicenses; ASSIGNEDSKUPARTNUMBER"/>
</ytriaAutomation>

XML