Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Transformation of table

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.

pic.png

Any idea how? Kindly advise.

Many thanks in advance!

1 Solution

Accepted Solutions
MarcoWedel

Hi,

maybe like this:

QlikCommunity_Thread_289874_Pic1.JPG

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

View solution in original post

3 Replies
MarcoWedel

please post some sample data (no image)

Anonymous
Not applicable
Author

There you go!

MarcoWedel

Hi,

maybe like this:

QlikCommunity_Thread_289874_Pic1.JPG

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