ExplodeTimes: Explode Time Values into Separate Columns

Tag: ExplodeTimes

The ExplodeTimes function expands (or explodes) times in the grid.

Tag Attributes

Attributes	Value Description
Target	Identifies the grid by name. Do not use, or use "grid" for main grid. No target necessary in sapio365.
ColumnID	Column UID shows the columns that aren't visible - selects the column like <SelectColumn ColumnID="..."/>

automation-explode-times

A column must be selected

Example Scripts

XML

<ExplodeTimes ColumnID="receivedDateTime"/>

XML

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