|
|
Archives of the TeradataForum
Message Posted: Wed, 21 Jan 2004 @ 20:39:41 GMT
Subj: | | Re: Pivoting a single attribute (normalizing) |
|
From: | | Victor Sokovin |
| An example of what I have been given is in the following table. | |
state_code county_code
48 1,2,3,4,5,6,7,8,9,10,11,12
| The format I would like to convert this to is in the table below. | |
state_code county_code
48 1
48 2
48 3
48 4
48 5
48 6
48 7
48 9
48 10
48 11
48 12
You might want to check out one of the recent threads which treats a more generic case:
www.teradataforum.com/teradata/20031231_175516.htm
Regards,
Victor
| |