topic Re: Transformation of table in QlikView https://community.qlik.com/t5/QlikView/Transformation-of-table/m-p/33837#M608086 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>maybe like this:</P><P><IMG alt="QlikCommunity_Thread_289874_Pic1.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/192454_QlikCommunity_Thread_289874_Pic1.JPG" style="height: auto; width: auto;" /></P><P></P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_macro_code _jivemacro_uid_15177832471035523 jive_text_macro" jivemacro_uid="_15177832471035523"> <P>table1:</P> <P>Generic</P> <P>LOAD *, 'Y'</P> <P><SPAN>FROM [</SPAN><A class="" data-containerid="-1" data-containertype="-1" data-objectid="313236" data-objecttype="13" href="https://community.qlik.com/servlet/JiveServlet/download/2061-289874-1428671-313236/data.xlsx">https://community.qlik.com/servlet/JiveServlet/download/1428671-313236/data.xlsx</A><SPAN>] (ooxml, embedded labels, table is Sheet2, filters(Replace(1, top, StrCnd(null))));</SPAN></P> </PRE><P></P><P></P><P>hope this helps</P><P></P><P>regards</P><P></P><P>Marco</P></BODY></HTML> Sun, 04 Feb 2018 22:27:55 GMT MarcoWedel 2018-02-04T22:27:55Z Transformation of table https://community.qlik.com/t5/QlikView/Transformation-of-table/m-p/33834#M608083 <HTML><HEAD></HEAD><BODY><P>Dear all,</P><P></P><P>I'm trying to transform a table, but without using reverse crosstable(<A _jive_internal="true" href="https://community.qlik.com/message/78337?&amp;_ga=2.98545631.1102423853.1517394539-2144894846.1510813567#78337">Link</A>) as I need to manipulate the results of Detail column. </P><P>i.e. I need the columns General, ADF, Fax Unit to tell the configurations of a machine. </P><P><IMG alt="pic.png" class="jive-image image-1" height="227" src="https://community.qlik.com/legacyfs/online/192099_pic.png" style="height: 227px; width: 769.071px;" width="769" /></P><P>Any idea how? Kindly advise. </P><P>Many thanks in advance!</P></BODY></HTML> Thu, 01 Feb 2018 08:38:03 GMT https://community.qlik.com/t5/QlikView/Transformation-of-table/m-p/33834#M608083 Anonymous 2018-02-01T08:38:03Z Re: Transformation of table https://community.qlik.com/t5/QlikView/Transformation-of-table/m-p/33835#M608084 <HTML><HEAD></HEAD><BODY><P>please post some sample data (no image)</P></BODY></HTML> Thu, 01 Feb 2018 20:50:07 GMT https://community.qlik.com/t5/QlikView/Transformation-of-table/m-p/33835#M608084 MarcoWedel 2018-02-01T20:50:07Z Re: Transformation of table https://community.qlik.com/t5/QlikView/Transformation-of-table/m-p/33836#M608085 <HTML><HEAD></HEAD><BODY><P>There you go!</P></BODY></HTML> Fri, 02 Feb 2018 03:08:19 GMT https://community.qlik.com/t5/QlikView/Transformation-of-table/m-p/33836#M608085 Anonymous 2018-02-02T03:08:19Z Re: Transformation of table https://community.qlik.com/t5/QlikView/Transformation-of-table/m-p/33837#M608086 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>maybe like this:</P><P><IMG alt="QlikCommunity_Thread_289874_Pic1.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/192454_QlikCommunity_Thread_289874_Pic1.JPG" style="height: auto; width: auto;" /></P><P></P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_macro_code _jivemacro_uid_15177832471035523 jive_text_macro" jivemacro_uid="_15177832471035523"> <P>table1:</P> <P>Generic</P> <P>LOAD *, 'Y'</P> <P><SPAN>FROM [</SPAN><A class="" data-containerid="-1" data-containertype="-1" data-objectid="313236" data-objecttype="13" href="https://community.qlik.com/servlet/JiveServlet/download/2061-289874-1428671-313236/data.xlsx">https://community.qlik.com/servlet/JiveServlet/download/1428671-313236/data.xlsx</A><SPAN>] (ooxml, embedded labels, table is Sheet2, filters(Replace(1, top, StrCnd(null))));</SPAN></P> </PRE><P></P><P></P><P>hope this helps</P><P></P><P>regards</P><P></P><P>Marco</P></BODY></HTML> Sun, 04 Feb 2018 22:27:55 GMT https://community.qlik.com/t5/QlikView/Transformation-of-table/m-p/33837#M608086 MarcoWedel 2018-02-04T22:27:55Z