Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
maherqawas
Contributor
Contributor

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

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:

maherqawas_0-1597306970821.png

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.

2 Replies
marcus_sommer

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

maherqawas
Contributor
Contributor
Author

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

take a look at this picture:

maherqawas_0-1597317410195.png

the table I meant shoud be placed there.