| Quote ID | HTML |
|---|
| 8501 | <tr> <td>Product ID</td><td>Part #</td><td>Product Description.</td> </tr> <tr> <td>Product ID</td><td>Part #</td><td>Product Description</td> </tr> |
| 8502 | <tr> <td>Product ID</td><td>Part #</td><td>Product Description.</td> </tr> <tr> <td>Product ID</td><td>Part #</td><td>Product Description</td> </tr> |
I have a Table that has Quote ID field and HTML field. The HTML Field has Many Product ID's that link to one Quote ID.
My objective is the convert the HTML field into it's own separate table and join it back to the original table with the Key Field Quote ID.
The issue that I have is that I do not know how I can get the Quote ID into the HTML Table so that I can then convert into a CSV file or whatever so that QlikView analyze the data and join it to the original table.
Any ideas? Should I even be attempting this?
