cuetzpalin
Programmer
Hi,
Thank for taking time to read my thread. I'm new to PL/SQL so I need some help.
I have a table with product codes that can be associated with more than one product category.
What I'm looking to do is create code that will look at all the product codes and basically loop through the table and create a new table with all the associated product categories for a particular product code.
Here's an example of the data:
Product code:
A145041
A452002
A145041
A245666
Product code: A145041 is in multiple Categories: Filters and Hardware.
So, in my final data set table I want to combine the Categories into one data fields.
It should look like this:
Product Code: A145041 Category: Filters, Hardware
Product Code: A452002 Category: Hardware
Product Code: A245666 Category: Film
I hope that makes sense.
Thank you so much in advance!
- C
Thank for taking time to read my thread. I'm new to PL/SQL so I need some help.
I have a table with product codes that can be associated with more than one product category.
What I'm looking to do is create code that will look at all the product codes and basically loop through the table and create a new table with all the associated product categories for a particular product code.
Here's an example of the data:
Product code:
A145041
Category: FiltersA452002
Category: HardwareA145041
Category: HardwareA245666
Category: FilmProduct code: A145041 is in multiple Categories: Filters and Hardware.
So, in my final data set table I want to combine the Categories into one data fields.
It should look like this:
Product Code: A145041 Category: Filters, Hardware
Product Code: A452002 Category: Hardware
Product Code: A245666 Category: Film
I hope that makes sense.
Thank you so much in advance!
- C
