DSXchange

Hi All,

I have a requirement like 1 -record need to be split into mutiple columns

Ex:Record:Batch 2|| incident ||casue||0001-10-09 00:00:00(Database)

I need to populate data according the table columns

==============================
Column name Datavalue
==============================
Batch Batch2
group incident
reason Cause
Date 0001-10-09 00:00:00
===================================

Please suggest me which stage i need to use and impliment

Thanks and Regards
Srini

use transformer stage

Specifically the Field() function can be used to break up your pipe delimited string. Because of the double pipes, you'll need to adjust your 'field number' accordingly. For example, "incident" would be the third (not second) field.

The 'sub fields' could then be broken further down using the same function.