Manualshelf

Data Transformation Engine Design Studio Tutorial

ManualsBrandsHP ManualsServerHP NonStop G-Series
141142143144145146147148149150
Chapter 6 - Using the OR Function with a Lookup File MakePreferredData Map
Design Studio Tutorial
146
2 In the parentheses, enter:
♦ The text_to_convert
♦ A comma (
,)
♦ The date_time_fo rmat_string enclosed in quotation marks
" "
The map rule for the first occurrence of the PurchaseDate Field is:
=TODATETIME ("010322","yymmdd")
Generating Customer[2] and Customer[3] Output
The text literals must be entered in the map rules for the second and third
occurrence of Customer.