https://community.qlik.com/t5/QlikView/How-can-I-convert-talbe-in-qv-script/m-p/226783#M78949 <HTML><HEAD></HEAD><BODY><P>I get the function . Thanks!</P><P>MyTab:<BR />Load MeetingID, Start, Stop,<BR />subfield(Participants, ';') as People<BR />from Tab1.csv;</P><P></P></BODY></HTML> Fri, 22 Apr 2011 04:22:05 GMT 2011-04-22T04:22:05Z https://community.qlik.com/t5/QlikView/How-can-I-convert-talbe-in-qv-script/m-p/226782#M78948 <HTML><HEAD></HEAD><BODY><P></P><P>Hi, I want to conert table 1 to 2 in qv script? can this be done in qv?</P><P></P><P>table1</P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 108pt; border-collapse: collapse;" width="144"><COLGROUP><COL span="2" style="width: 54pt;" width="72" /></COLGROUP><TBODY><TR height="18" style="height: 13.5pt;"><TD class="xl65" height="18" style="background-color: transparent; width: 54pt; height: 13.5pt; border: windowtext 0.5pt solid;" width="72">A</TD><TD class="xl65" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; width: 54pt; border-top: windowtext 0.5pt solid; border-right: windowtext 0.5pt solid;" width="72">RED|BLUE|GREEN</TD></TR></TBODY></TABLE><BR /><BR /> <P>table2</P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 108pt; border-collapse: collapse;" width="144"><COLGROUP><COL span="2" style="width: 54pt;" width="72" /></COLGROUP><TBODY><TR height="18" style="height: 13.5pt;"><TD class="xl65" height="18" style="background-color: transparent; width: 54pt; height: 13.5pt; border: windowtext 0.5pt solid;" width="72">A</TD><TD class="xl65" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; width: 54pt; border-top: windowtext 0.5pt solid; border-right: windowtext 0.5pt solid;" width="72">RED</TD></TR><TR height="18" style="height: 13.5pt;"><TD class="xl65" height="18" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext 0.5pt solid; background-color: transparent; height: 13.5pt; border-top: windowtext; border-right: windowtext 0.5pt solid;">A</TD><TD class="xl65" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;">BLUE</TD></TR><TR height="18" style="height: 13.5pt;"><TD class="xl65" height="18" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext 0.5pt solid; background-color: transparent; height: 13.5pt; border-top: windowtext; border-right: windowtext 0.5pt solid;">A</TD><TD class="xl65" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;">GREEN</TD></TR></TBODY></TABLE><BR /><BR /></BODY></HTML> Fri, 22 Apr 2011 04:15:12 GMT https://community.qlik.com/t5/QlikView/How-can-I-convert-talbe-in-qv-script/m-p/226782#M78948 2011-04-22T04:15:12Z https://community.qlik.com/t5/QlikView/How-can-I-convert-talbe-in-qv-script/m-p/226783#M78949 <HTML><HEAD></HEAD><BODY><P>I get the function . Thanks!</P><P>MyTab:<BR />Load MeetingID, Start, Stop,<BR />subfield(Participants, ';') as People<BR />from Tab1.csv;</P><P></P></BODY></HTML> Fri, 22 Apr 2011 04:22:05 GMT https://community.qlik.com/t5/QlikView/How-can-I-convert-talbe-in-qv-script/m-p/226783#M78949 2011-04-22T04:22:05Z