ImplodeAllDateTimes: Implode all date and times | Automation

Tag: ImplodeAllDateTimes

The ImplodeAllDateTimes function collapses (or implodes) all the dates and times in the grid that were previously expanded (or exploded).

The columns containing the separated values are removed.

automation-implode-all-dates-times

Tag Attributes

Attributes	Attribute Value	Comment
Target	Grid name	Optional: identifies the grid. Not needed in sapio365.

Example Scripts

XML

<ImplodeAllDateTimes/>

XML

<ytriaAutomation>
	<ShowMyDataMail>
		<Select Lines="ByValue">
			<SetParam ColumnID="senderName" Value="Alex Wilber"/>
		</Select>
		<SelectColumn ColumnID="toRecipientsAddresses"/>
		<ExplodeMultivalues ColumnID="toRecipientsAddresses"/>
		<SelectColumn ColumnID="receivedDateTime"/>
		<ExplodeDates/>
		<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>