Transpose?

Get help with installation and running here.

Moderators: DataMystic Support, Moderators, DataMystic Support, Moderators, DataMystic Support, Moderators

Post Reply
kristov
Posts: 1
Joined: Thu Sep 23, 2004 7:44 am

Transpose?

Post by kristov »

I have a csv file and am wondering if TextPipe can TRANSPOSE it.

Basically, my text comes out as

Hour,1,2,3,4,5
Temp,60,61,62,63

and i want it to be transposed to a table format

Hour Temp
1 60
2 61
3 62
4 63

Here is an actual dataset

Hour,11,12,13,14,15,16,17,18,19,20,21,22,23,0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,0,1,2,3,4,5,6,7,8,9,10
Temp,63,64,68,69,72,69,72,71,67,65,62,61,59,59,58,56,55,55,54,53,53,55,58,62,65,66,69,70,73,71,73,72,68,66,63,61,59,59,58,56,55,55,54,53,53,55,59,63,66,67,71,71,75,72,75,73,70,67,64,62,61,59,58,57,56,55,55,54,54,55,57,60
Cloudiness,47,70,70,70,70,70,70,70,70,70,70,70,70,59,59,59,59,59,59,72,72,72,72,72,72,45,45,45,45,45,45,42,42,42,42,42,42,90,90,90,90,90,90,90,90,90,90,90,90,35,35,35,35,35,35,46,46,46,46,46,46,46,46,46,46,46,46,46,46,46,46,46
Dewpoint,55,53,52,51,49,56,52,56,53,54,54,53,52,53,49,49,50,50,50,50,50,51,53,54,55,53,51,50,48,57,51,56,53,55,55,54,52,53,49,49,51,51,51,51,51,52,54,55,56,54,52,51,48,57,52,56,51,51,51,51,51,50,50,50,50,50,50,50,50,50,50,50
Relative Humdity,75,67,56,52,44,63,49,59,60,67,75,74,77,80,71,77,83,83,86,89,89,86,83,75,70,62,52,49,41,61,46,57,58,67,75,77,77,80,71,77,86,86,89,92,92,89,83,75,70,63,51,49,38,59,44,55,50,56,62,67,69,72,74,77,80,83,83,86,86,83,77,69
Wind,NW,N,N,N,N,N,N,NW,NW,NW,NW,NW,NW,NW,NW,NW,NW,NW,NW,N,N,N,N,N,N,N,N,N,N,N,N,NW,NW,NW,NW,NW,NW,NW,NW,NW,NW,NW,NW,NW,NW,NW,NW,NW,NW,NW,NW,NW,NW,NW,NW,NW,NW,NW,NW,NW,NW,NW,NW,NW,NW,NW,NW,SW,SW,SW,SW,SW
Wind Speed,1,3,3,3,3,3,3,2,2,2,2,2,2,2,2,2,2,2,2,1,1,1,1,1,1,5,5,5,5,5,5,3,3,3,3,3,3,1,1,1,1,1,1,2,2,2,2,2,2,5,5,5,5,5,5,4,4,4,4,4,4,4,4,4,4,4,4,3,3,3,3,3

We are wondering if TextPipe is capable of this - i havent been able to see it happening.

Thanks,

Chris
User avatar
DataMystic Support
Site Admin
Posts: 2227
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia
Contact:

Post by DataMystic Support »

See the included filter conversions\pivot csv file.fll
Post Reply