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.
multiple records
Moderators: chulett, rschirm, roy
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
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
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
length
Hi DSguru,
The conditional operator is and here.
Thanks
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,
Regards,
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.