DSXchange

Hi All,
This is one of the requirement, need help whenever an M starts the data has to be entered in a new row.

Regards
Prasad

Hi Prasad,
If col1 values are consistent( 'M','C' & 'U').

Use the transformer stage to filter the col1 using constarints and to get three output streams.Define a common dummy column in all three outstreams with the same constant value.Next use the merge stage to merge all the three streams.
Or you can do the same using filter,modify and merge stages.

[/quote]

meena wrote:Hi Prasad,
If col1 values are consistent( 'M','C' & 'U').

Use the transformer stage to filter the col1 using constarints and to get three output streams.Define a common dummy column in all three outstreams with the same constant value.Next use the merge stage to merge all the three streams.
Or you can do the same using filter,modify and merge stages.

Code: Select all

Input data

col1|col2

M|abc
C|def
U|hji
M|ad
U|ryer
M|fntry
C|rtf
U|gsfdg


Ouput 
col1|col2|col3 |col4|col5|col6

M|abc|C|def|U|hji
M|ad|	|	|U|ryer
M|fntry|C|rtf|U|gsfdg

[/quote]

As you can see in the sample data shown M, C and U are not consistent, there might be
M and C, or
M and U or
M, C and U present.
As they are not consistent I guess we cannot use merge stage to merge the data.

prasad111 wrote:

meena wrote:Hi Prasad,
If col1 values are consistent( 'M','C' & 'U').

Use the transformer stage to filter the col1 using constarints and to get three output streams.Define a common dummy column in all three outstreams with the same constant value.Next use the merge stage to merge all the three streams.
Or you can do the same using filter,modify and merge stages.

Code: Select all

Input data

col1|col2

M|abc
C|def
U|hji
M|ad
U|ryer
M|fntry
C|rtf
U|gsfdg


Ouput 
col1|col2|col3 |col4|col5|col6

M|abc|C|def|U|hji
M|ad|	|	|U|ryer
M|fntry|C|rtf|U|gsfdg

As you can see in the sample data shown M, C and U are not consistent, there might be
M and C, or
M and U or
M, C and U present.
As they are not consistent I guess we cannot use merge stage to merge the data.[/quote]

A transformer will do the trick...You know at the sight of 'M' a new row is to be written...If you encounter a C or an U after a M, you can hold them in stage variable and write this row when you encounter the next 'M'
Helps ?? or confusing ??

prasad111 wrote:

meena wrote:Hi Prasad,
If col1 values are consistent( 'M','C' & 'U').

Use the transformer stage to filter the col1 using constarints and to get three output streams.Define a common dummy column in all three outstreams with the same constant value.Next use the merge stage to merge all the three streams.
Or you can do the same using filter,modify and merge stages.

Code: Select all

Input data

col1|col2

M|abc
C|def
U|hji
M|ad
U|ryer
M|fntry
C|rtf
U|gsfdg


Ouput 
col1|col2|col3 |col4|col5|col6

M|abc|C|def|U|hji
M|ad|	|	|U|ryer
M|fntry|C|rtf|U|gsfdg

As you can see in the sample data shown M, C and U are not consistent, there might be
M and C, or
M and U or
M, C and U present.
As they are not consistent I guess we cannot use merge stage to merge the data.[/quote]

A transformer will do the trick...You know at the sight of 'M' a new row is to be written...If you encounter a C or an U after a M, you can hold them in stage variable and write this row when you encounter the next 'M'
Helps ?? or confusing ??

Follow this link and see whether that can move you in a proper direction:

viewtopic.php?t=99149&postdays=0&postor ... ge&start=0

sAM

vijayrc and us1aslam1us reply was very helpful.

Thanks a lot.............