My Pages

Search This Blog

Friday, July 8, 2011

A Column having multiple values to separate rows

Here consider the source and target as flatfiles
Source
id area
1 123,456-234,245,000
2 456,123,567-123,090
3 586,789,567-123,234

Target
id|area
1|"123"
2|"456"
3|"586"
1|"456-234"
2|"123"
3|"567"
1|"245"
2|"567-123"
3|"789"
1|"000"
2|"090"
3|"967-423"

Please share you solutions to others as comments



Cheers
-Winkey

No comments:

Post a Comment