harperjo
New Member
- Joined
- Aug 13, 2009
- Messages
- 7
I have a csv table that I have to do some converting on to be used as an import for a database load. An example would be similar to the table below. of course I have 225 attributes in the table to deal with.
<tbody>
</tbody>
the conversion question is this.....I have to take this csv above and turn it into the one below.
<tbody>
</tbody>
the attributes headers and the values get transposed (if they exist)
any ideas on how to get this working?
ID | description | type | attrib1 | attrib2 | attrib3 | attrib4 |
1 | EXFAN223 | fan01 | 1750 | 5blade | belt | |
2 | SUPFAN01 | fan02 | 2300 | 25" | squirrel | direct |
3 | EXFAN109 | fan01 | 1750 | 3blade | belt | |
<tbody>
</tbody>
the conversion question is this.....I have to take this csv above and turn it into the one below.
ID | description | type | attribute | value |
1 | EXFAN223 | fan01 | attrib1 | 1750 |
1 | EXFAN223 | fan01 | attrib3 | 5blade |
1 | EXFAN223 | fan01 | attrib4 | belt |
2 | SUPFAN01 | fan02 | attrib1 | 2300 |
2 | SUPFAN01 | fan02 | attrib2 | 25" |
2 | SUPFAN01 | fan02 | attrib3 | squirrel |
2 | SUPFAN01 | fan02 | attrib4 | direct |
3 | EXFAN109 | fan01 | attrib1 | 1750 |
3 | EXFAN109 | fan01 | attrib3 | 3blade |
3 | EXFAN109 | fan01 | attrib4 | belt |
<tbody>
</tbody>
the attributes headers and the values get transposed (if they exist)
any ideas on how to get this working?