Transformation of table

[Anonymous]

Dear all,

I'm trying to transform a table, but without using reverse crosstable(Link) as I need to manipulate the results of Detail column.

i.e. I need the columns General, ADF, Fax Unit to tell the configurations of a machine.

Any idea how? Kindly advise.

Many thanks in advance!

[MarcoWedel]

please post some sample data (no image)

[Anonymous]

There you go!

[MarcoWedel · Accepted solution]

Hi,

maybe like this:

table1:
Generic
LOAD *, 'Y'
FROM [https://community.qlik.com/servlet/JiveServlet/download/1428671-313236/data.xlsx] (ooxml, embedded labels, table is Sheet2, filters(Replace(1, top, StrCnd(null))));

hope this helps

regards

Marco