topic How do I structure a qlikview table? in QlikView

How do I structure a qlikview table?

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

The database we are extracting from is based on the following structure - duplicate record numbers with fields we wish to extract from multiple rows.

What would be simplest way to show this data in qlikview in the format below?

Record	Age	Gender	Service
1	21	Male	2
2	44	Female	20
3	38	Male	5

Any advice would be appreciated.

Thanks,

Paul

sudeepkm — Thu, 21 Sep 2017 13:31:22 GMT

one way is to use Generic load like below. Then create a table box adding all the fields.

Generic

LOAD Record,

Question,

Answer

FROM

(html, codepage is 1252, embedded labels, table is @1);

krishnacbe — Thu, 21 Sep 2017 13:38:25 GMT

Hope the Attached file will help