Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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
please post some sample data (no image)
There you go!
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