Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
michael_gardner
Contributor III

One to Many HTML Field

Quote IDHTML
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?

1 Solution

Accepted Solutions

Re: One to Many HTML Field

See attached qvw.


talk is cheap, supply exceeds demand
2 Replies

Re: One to Many HTML Field

See attached qvw.


talk is cheap, supply exceeds demand
michael_gardner
Contributor III

Re: One to Many HTML Field

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

Community Browser