Field Function in Transformer Stage

Some times we get all the columns in single column like below

xyztable

1,sam,clerck,2000

2,tim,salesman,2100

3,pom,clerck,1800

4,jam,pa,1900

5,emy,clerck,2500

Read and Load the data in sequential file stage.

In Transformer Stage Create Columns as

e_id, e_name,e_job,e_sal

and in all derivations write as below

Field(dslink3.xyztable,’,’,1) for e_id

Field(dslink3.xyztable,’,’,2) for e_name

Field(dslink3.xyztable,’,’,3) for e_job

Field(dslink3.xyztable,’,’,4) for e_Sal

Give File name at the target

Compile and Run the Job

That’s it you will get the 4 columns with required data.