Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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.