which stage to use

[prasad111]

Hi All,
This is one of the requirement, need help

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

whenever an M starts the data has to be entered in a new row.

Regards
Prasad

[meena]

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]

[prasad111]

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.

[vijayrc]

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 ??

[vijayrc]

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 ??

[us1aslam1us]

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

[prasad111]

vijayrc and us1aslam1us reply was very helpful.

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