I need consolidate columns from a table. I have a table will 3 group id and attribute id columns. I need to create a separate record for each group of attribute groups and attribute ids. Basically, i need a table with just one column for the attribute group and ID.
Table A:
RecID GroupID AttributeID GroupID1 AttributeID1 GroupID2 AttributeID 2
------- --------- ----------- ---------- ------------- ---------- --------------
1 Cars 100 Doors 134 Sinks 499
2 Filters 450 Paint 344
Expected Results:
RecID GroupID AttributeID
------- --------- -----------
1 Cars 100
1 Doors 134
1 Sinks 499
2 Filters 450
2 Paint 344
Table A:
RecID GroupID AttributeID GroupID1 AttributeID1 GroupID2 AttributeID 2
------- --------- ----------- ---------- ------------- ---------- --------------
1 Cars 100 Doors 134 Sinks 499
2 Filters 450 Paint 344
Expected Results:
RecID GroupID AttributeID
------- --------- -----------
1 Cars 100
1 Doors 134
1 Sinks 499
2 Filters 450
2 Paint 344
Learn from the best
Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.
Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 5 Comments.
Try for 7 days”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.
Our community of experts have been thoroughly vetted for their expertise and industry experience.