Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
kchuying
Contributor II
Contributor II

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)

kchuying
Contributor II
Contributor II
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

View solution in original post