Using Columns as a header

Nitaci — Sat, 19 Nov 2022 09:57:34 GMT

Dear all,

I have a table, which I can load throught standard load, that looks like

| Name | Subname | Value |
+-------+---------+-------+
| Name1 | Sname1 | A |
+-------+---------+-------+
| Name1 | Sname2 | B |
+-------+---------+-------+
| Name2 | Sname1 | C |
+-------+---------+-------+
| Name2 | Sname2 | D |
+-------+---------+-------+
| Name2 | Sname3 | E |
+-------+---------+-------+
| Name3 | Sname1 | F |
+-------+---------+-------+

I would like to transform this table so that the Subname is used as a header, i.e. I would like to recieve

| | Sname1 | Sname2 | Sname3 |
|-----------|------------|-------------|------------|
| Name1 | A | B | C |
| Name2 | D | E | |
| Name3 | G | | |

I have tried just loading the data and then using pivot tabel, but I have had no such luck.
Any suggestions?

Re: Using Columns as a header

MarcoWedel — Sat, 19 Nov 2022 11:30:29 GMT

try using a generic load:

https://help.qlik.com/en-US/qlikview/May2022/Subsystems/Client/Content/QV_QlikView/Scripting/ScriptPrefixes/Generic.htm

topic Using Columns as a header in QlikView

Using Columns as a header

Re: Using Columns as a header