DSXchange

Hi All,

I am concatenating three fields say x,y,z
if length of x,y,z is greater than say 10 bytes, then create multiple records with 10 bytes in each record.

can some one let me how to solve this.


Thanks in advance.

Well there are several ways. Try using the search facility as well. Try thispost as well.
Also, you need to provide more info, is the conditional operand suppose to be and, or ,either or with the lengths of x,y,z.
To split a row into mulitple rows has been discussed here a lot. Like say for eg: in your recent post

Hi DSguru,

The conditional operator is and here.

Thanks

DSguru2B wrote:Well there are several ways. Try using the search facility as well. Try thispost as well.
Also, you need to provide more info, is the conditional operand suppose to be and, or ,either or with the lengths of x,y,z.
To split a row into mulitple rows has been discussed here a lot. Like say for eg: in your recent post

As advised earlier, go through the posts i have referenced. If still your not able to do it then give the number of columns coming in from your input file and how it should be transformed, with sample data (before and after) to help us advise a solution without much exchange of posts in understanding the requirement.
Regards,