In a sample set of data, the format of my input file appears as follows:
CUST ID, HOME_PHONE, BUS_PHONE, ALT_PHONE
I'd like to normalize the data so that the output appears as follows:
CUST_ID, PHONE_NUM, PHONE_TYPE
The PHONE_TYPE column would reflect whether the value in PHONE_NUM was sourced from the HOME, BUS or ALT column.
Is this possible using the Pivot stage?
Thanks!
Pivot Stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom