Documentation Center

Viz Channel Branding User Guide

Version 5.0 | Published July 10, 2023 ©

Merging Fields

The ability to join fields is to be able to right in the Mapping Table for an import module be able to store info and instantly re-use it to another mapped variable. By default the variable Begin_at is mapped up to be a merge of Date and Time field, with a value-separator.

Example

date = /date/

time = /time/

begin_at = @dateT@time

IMPORTANT! The merging field must be located in the table after its parts-fields.

Example 1 for Fixed Width Any Text Import Type

  • StartHour = $L(1,2)

  • StartMin = $L(3,4)

  • StartSecond = $L(5,6)

  • Begin = @StartHour:@StartMin:@StartSecond

Example 2 for Delimited Any Text Import Type

  • StartHour = $L(4)

  • StartMin = $L(5)

  • StartSecond = $L(6)

  • Begin = @StartHour:@StartMin:@StartSecond

Example 3 for Any XML Import Type

This example shows time read in a format HH-MM-SS-FF from an entry /begin_time/time/.

  • TheStartTime = /begin_time/time/

  • StartHour = &(TheStartTime,”-”,1,1)

  • StartMin = &(TheStartTime,”-”,2,1)

  • StartSecond = &(TheStartTime,”-”,3,1)

  • StartFrame = &(TheStartTime,”-”,4,1)

  • Begin = @StartHour:@StartMin:@StartSecond:@StartFrame