我正在尝试将单列值拆分为多行,对于拆分文本似乎我已经成功了,但我还希望基于另一个列的值创建新的行。
| Order_id| Customer| Product |
----------------------------------------------
| 1 | John | table, chair, cabinet |
| 2 | Bob | table, chair |
| 3 | Dylan | cabinet |
我的期望结果将如下所示:
| Order_id| Customer| Product |
----------------------------------------------
| 1 | John | table |
| 1 | John | chair |
| 1 | John | cabinet |
| 2 | Bob | table |
| 2 | Bob | chair |
| 3 | Dylan | cabinet |