- How to split one column into different with new filed. I
have one column with 24 hour time format i want it to convert to AM, PM.
a. I
have the source data in three columns like Col1, Col2 and Col3.
b. Take
SQ and connect it to ROUTER transformation.
c. Take
one group and write the shown condition for suppurate 0-11 as 12 am to 11 am.
d. Remaining
will be pm in default group.
e. Connect
two groups to two different EXPRESSION
transformations.
f. In
first EXPRESSION TRANSFORMATION for AM, take the new port as variable port
and give the condition shown as below in the picture.
g. In
second EXPRESSION TRANSFORMATION for
PM, take the new port as variable
port and give the condition shown as below in the picture.
h. Finally connect the all ports to the target
and its instance respectively.
OUT PUT
No comments:
Post a Comment