Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

kchuying
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
Not applicable

Re: Transformation of table

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

3 Replies
MarcoWedel
Not applicable

Re: Transformation of table

please post some sample data (no image)

kchuying
Not applicable

Re: Transformation of table

There you go!

MarcoWedel
Not applicable

Re: Transformation of table

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