topic Re: Is there any way to build a HTML table using the cells' values in Excel in QlikView

Is there any way to build a HTML table using the cells' values in Excel

maherqawas — Wed, 25 Nov 2020 16:16:04 GMT

I have an excel document containing some of our new products, for which we need a good description.

In the Excel sample file attached to this question you will find 2 sample variation articles colored in blue and white.

The first one have some technical data as you see in this picture:

The second one has also some technical data, but different from the first article, and so on for the rest of the articles in the original excel file and the number of variants is not the same for all articles.

Is there anyway to build a HTML table out of this technical data, which contains all of them and have it in a separate column for each artikel? I hope someone could help me with that.

Re: Is there any way to build a HTML table using the cells' values in Excel

marcus_sommer — Thu, 13 Aug 2020 11:06:40 GMT

It's not quite clear to me what you mean with building a HTML table - where and for what?

If I look on the Excel I would quite probably load the data with a crosstable-statement to transform the content into a "normal" data-structure. The html marker have no use in QlikView and could then be removed or replaced with any string-functions or a mapping with mapsubstring().

- Marcus

Re: Is there any way to build a HTML table using the cells' values in Excel

maherqawas — Thu, 13 Aug 2020 11:17:29 GMT

We need for every article a description, and normally we use a html code for this

take a look at this picture:

the table I meant shoud be placed there.