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