One to Many HTML Field

Anonymous — Wed, 02 Apr 2014 18:07:50 GMT

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>

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?

Re: One to Many HTML Field

Gysbert_Wassenaar — Wed, 02 Apr 2014 19:07:56 GMT

See attached qvw.

Re: One to Many HTML Field

Anonymous — Wed, 02 Apr 2014 19:25:34 GMT

Gysbert...you are a Genious Legend! I didn't think it would be so easy.

topic Re: One to Many HTML Field in QlikView

One to Many HTML Field

Re: One to Many HTML Field

Re: One to Many HTML Field