DSXchange

If for a account number there are multiple values are present in another field, how can I take each value and propagate it to different fields.For e.g. if there are multiple dates for a single account no coming from a single source field,and in the target there are different target columns are present where we need to propagate the respective values.The first date should go to the firstcolumn , the second should should go to the second column and thus so on.How to implement this in datastage PX.

Investigate the use of the Field() function.

It would be easier to answer if you could illustrate your problem with an example, for instance the multiple dates - are they in a single column with a separator, or in distinct columns?

More information is required about how these multiple values are stored in their single field. Without that, no cogent reply can be given - different techniques are available to handle different layouts.

I thought mine was pretty cogent, given what I had to work with.

... unless the data in the field are:
fixed-width undelimited format
buried in free-form text
gibberish*


* this does not mean "from Gibraltar"

Read the source (im considering your source is a delimited text file) file in one column, using a sequential file stage, then use a transformer and use fiel function to seperate it to different fields, or you can also use a Column import stage.