How do I structure a qlikview table?

[Anonymous]

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

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

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 · Accepted solution]

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

Generic

LOAD Record,

     Question,

     Answer

FROM

[https://community.qlik.com/thread/275410]

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

[krishnacbe]

Hope the Attached file will help