DSXchange

i have data IN A SEQUENTIAL FILE LIKE
1|2|3
4|5|6
7|8|9
Now i want to convert this data to 123456789 in a single row.
My job is sequentilal file----->row merger----->sequential file
When i run the job by selecting MULTIPLE LINES my ouput file looks like
1|2|3
4|5|6
7|8|9 (when i checke in output sequential file)
But the output link frin rowmerger gives a count of 1, but still i am able to see 3 rows in output. What is this behaviour. And also if i wnat to concatenate only two columns in each row, how can i do this. What kind of derivaations can i use in Derivation field of Row Merger

just4u_sharath wrote:i have data IN A SEQUENTIAL FILE LIKE
1|2|3
4|5|6
7|8|9
Now i want to convert this data to 123456789 in a single row.
My job is sequentilal file----->row merger----->sequential file
When i run the job by selecting MULTIPLE LINES my ouput file looks like
1|2|3
4|5|6
7|8|9 (when i checke in output sequential file)
But the output link frin rowmerger gives a count of 1, but still i am able to see 3 rows in output. What is this behaviour. And also if i wnat to concatenate only two columns in each row, how can i do this. What kind of derivaations can i use in Derivation field of Row Merger

I got rid of delimiters.
Nou my output data looks like 1|2|34|5|67|8|9. How can i get rid of these pipe delimiters in output

What do you want to replace them with? Use a Convert() function.

ray.wurlod wrote:What do you want to replace them with? Use a Convert() function. ...

Use the below code to remove the pipeline symbol

Convert('|','',<FieldName>)

hello just4u_sharath


i am facing the same problem, i am seeing 3 rows in output, but i want them to be in single rows like 123456789 for input

1;2;3
4;5;6
7;8;9

i see
1;2;3
4;5;6
7;8;9 in output.

can you please help.

Use a stage variable to accumulate via concatenation and constrain the transformer stage to emit output only every third row.

Hello Ray is it not possible with row merger stage.

Neither is Convert(). I thought you may be considering other stage types. Can you post how you are attempting to merge the rows with the Row Merger stage?

if i concatinate all three input columns in a StageVar= col1:col2:col3
and then put this constraint in the transformer Mod(@INROWNUM,3)=0, it will just give me every third row and in this care 789 ? but we need 123456789 ? no ? what if we have more than three rows ? say a thousand ?

Hi,

I used the following design:
seq file ---- transformer-----seq file

My input was like

1|2|3
4|5|6
7|8|9
11|12|13
14|15|16
17|18|19

In the first seq file,

I didn't not specify any end delimiter or field delimiter.

In Transformer,

I used two stage variables for doing this task.

Ist stage variable:(stagevar)

If Mod(@INROWNUM,3) =1 Then DSLink2.INPUT Else If Mod(@INROWNUM,3) =2 Then StageVar:DSLink2.INPUT Else StageVar:DSLink2.INPUT

2nd stage variable:(stagevar1)

Convert("|","", StageVar)

OUTPUT:

123456789
111213141516171819

Hope this helps...

Thanks,
savis