split multiple rows

snt_ds · Post by **snt_ds** » Tue Sep 16, 2008 2:28 am

hi,

how to split multiple records based on delimiter

source is 1#2#3#4#5 ..n

it should be present in target like this
Ans
-------
1
2
3
4
5
.
.
n

Regds
Ramesh

varaprasad · Post by **varaprasad** » Tue Sep 16, 2008 2:56 am

specify the record delimiter as '#' in the file format properties.

ray.wurlod · Post by **ray.wurlod** » Tue Sep 16, 2008 3:08 am

Parse into separate columns then run these through a Pivot stage.

snt_ds · Post by **snt_ds** » Tue Sep 16, 2008 3:12 am

ray.wurlod wrote:Parse into separate columns then run these through a Pivot stage.

Thanks Ray
But the value of 'n' is not fixed.
please suggest.

ray.wurlod · Post by **ray.wurlod** » Tue Sep 16, 2008 3:16 am

Configure enough columns for the largest expected N.

ray.wurlod · Post by **ray.wurlod** » Tue Sep 16, 2008 3:17 am

Convert the # to @VM and load into a hashed file with a key generated as @OUTROWNUM. Then read from the hashed file dynamically normalized on your multi-valued column. You will need to set up the table definition with the "supports multi-valued columns" check box selected.

varaprasad · Post by **varaprasad** » Tue Sep 16, 2008 3:19 am

I mentioned 'record delimiter' NOT 'field delimiter'
I believe it should work in ur scenario.