Hi am sundar, i have datas like
00023-1010
00086-1010
00184F2-1010
.
.
.
.
SCH-AS-1010
200-0196-039
.
.
.
Now i want the result as values before the delimiter should
come under the column ITEM_CODE and values after the
delimiter should come under the column LOC_CODE.. But some
datas like "SCH-AS-1010", for this, "SCHAS" should come
under the column ITEM_CODE and 1010 should come under the
column LOC_CODE.. Pls help me..
Answer / kiran
hi this is kiran..,
u can do manipulate in transformer stage.in tranformer
stage some functions is ther like
FIELD('sring',delimeter,occurence.....) like that
A=Field('SCH-AS-1010','-',1)
B=Field('SCH-AS-1010','-',2)
C=Field('SCH-AS-1010','-',3)
then
concatenate A and B in ITEM_CODE C in LOC_CODE.
| Is This Answer Correct ? | 7 Yes | 1 No |
How to read multiple files using a single datastage job if files have the same metadata?
CHANGE CAPTURE
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise
Can we use sequential file as source to hash file? Have you do it ?if what error it will give?
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
how to write server Routine coding?
Hi any one has datasatge 8.5 certication dump could you please provide your details i will contact you. send reply to my mail rajaadivi@gmail.com Thanks in Advance
Have you have ever worked in unix environment and why it is useful in datastage?
Name the different types of Lookups in Datastage?
how to call routines in stages?
What is RCP
how to export or import the jobs in .ISX file