Tag: ExplodeMultivalues

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

<ExplodeMultivalues/>
XML

Tag Attributes

AttributesAttribute ValuesValue DescriptionComment
TargetM/AIdentifies the grid by name
Do not use "grid" for main grid.
No target is necessary in sapio365
N/A
ColumnIDN/AThe 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