#1 2012-04-30 13:53:33

oscarmsanz
Member
Registered: 1970-01-01
Posts: 78

convert rows to column

Hi

I have a tab-delimited file

dni 50112256T
telephone 123456789

I want to end up having a tab-delimited file

dni phone
123456789 50112031

a greeting
Oscar Manso

Offline

#2 2012-04-30 22:27:15

phobucket
Member
Company: Knoetry
Registered: 2010-07-27
Posts: 146
Website

Re: convert rows to column

Hi Oscar,

If I understand you correctly, col1 has dni and telephone, and  col2 as the dni or phone value, right?  On the output you want 2 columns, one for the dni, one for the phone. 

Send the input into a tmap and concatenate cols 1 and 2 into single delimited output column. 
      row1.col1 + ";" + row1.col2

The send the output of the tmap into a tDenormalize component.

Is this what you are looking for?

Thanks,
Ben

Offline

#3 2012-05-03 00:10:28

oscarmsanz
Member
Registered: 1970-01-01
Posts: 78

Re: convert rows to column

hi

Hi phobucket

Ok, thanks.



Regards,
Oscar Manso

Offline

Board footer

Powered by FluxBB