topic Read Array Type Field -- FieldList in QlikView https://community.qlik.com/t5/QlikView/Read-Array-Type-Field-FieldList/m-p/433302#M699685 <HTML><HEAD></HEAD><BODY><P>Hi Folks,</P><P></P><P>I read the Excel file data into QV application. But I got the data below patten.</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 581px;"><TBODY><TR><TD class="xl68" height="21" width="65"><STRONG>L-ID</STRONG></TD><TD class="xl69" style="border-left: none;" width="64"><STRONG>M-ID</STRONG></TD><TD class="xl69" style="border-left: none;" width="64"><STRONG>T-ID</STRONG></TD><TD class="xl70" style="border-left: none;" width="388"><STRONG>Groups Combination</STRONG></TD></TR><TR><TD class="xl65" height="21">A</TD><TD class="xl66" style="border-left: none;">B</TD><TD class="xl66" style="border-left: none;">C</TD><TD class="xl67" style="border-left: none;">[[RC1[RC1BOATA:RC1BOATB]]:[RC2[RC2BOATA:RC2BOATB]]]</TD></TR></TBODY></TABLE><P></P><P>and my desired out put table format like</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 581px;"><TBODY><TR><TD class="xl69" height="20" width="65"><STRONG>L-ID</STRONG></TD><TD class="xl70" style="border-left: none;" width="64"><STRONG>M-ID</STRONG></TD><TD class="xl70" style="border-left: none;" width="64"><STRONG>T-ID</STRONG></TD><TD class="xl71" style="border-left: none;" width="388"><STRONG>Process Flow</STRONG></TD></TR><TR><TD class="xl66" height="20" style="border-top: none;">A</TD><TD class="xl65" style="border-top: none; border-left: none;">B</TD><TD class="xl65" style="border-top: none; border-left: none;">C</TD><TD class="xl72" style="border-top: none; border-left: none;">RC1-RC1BOATA</TD></TR><TR><TD class="xl66" height="20" style="border-top: none;">A</TD><TD class="xl65" style="border-top: none; border-left: none;">B</TD><TD class="xl65" style="border-top: none; border-left: none;">C</TD><TD class="xl72" style="border-top: none; border-left: none;">RC1-RC1BOATB</TD></TR><TR><TD class="xl66" height="20" style="border-top: none;">A</TD><TD class="xl65" style="border-top: none; border-left: none;">B</TD><TD class="xl65" style="border-top: none; border-left: none;">C</TD><TD class="xl72" style="border-top: none; border-left: none;">RC2-RC1BOATA</TD></TR><TR><TD class="xl67" height="21" style="border-top: none;">A</TD><TD class="xl68" style="border-top: none; border-left: none;">B</TD><TD class="xl68" style="border-top: none; border-left: none;">C</TD><TD class="xl73" style="border-top: none; border-left: none;">RC2-RC1BOATB</TD></TR></TBODY></TABLE><P></P><P>Please help how to read in qlikview.</P><P></P><P>Thanks in Adnavce....</P><P></P><P></P><P>Regards,</P><P>Siri</P></BODY></HTML> Fri, 19 Oct 2012 12:38:44 GMT 2012-10-19T12:38:44Z Read Array Type Field -- FieldList https://community.qlik.com/t5/QlikView/Read-Array-Type-Field-FieldList/m-p/433302#M699685 <HTML><HEAD></HEAD><BODY><P>Hi Folks,</P><P></P><P>I read the Excel file data into QV application. But I got the data below patten.</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 581px;"><TBODY><TR><TD class="xl68" height="21" width="65"><STRONG>L-ID</STRONG></TD><TD class="xl69" style="border-left: none;" width="64"><STRONG>M-ID</STRONG></TD><TD class="xl69" style="border-left: none;" width="64"><STRONG>T-ID</STRONG></TD><TD class="xl70" style="border-left: none;" width="388"><STRONG>Groups Combination</STRONG></TD></TR><TR><TD class="xl65" height="21">A</TD><TD class="xl66" style="border-left: none;">B</TD><TD class="xl66" style="border-left: none;">C</TD><TD class="xl67" style="border-left: none;">[[RC1[RC1BOATA:RC1BOATB]]:[RC2[RC2BOATA:RC2BOATB]]]</TD></TR></TBODY></TABLE><P></P><P>and my desired out put table format like</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 581px;"><TBODY><TR><TD class="xl69" height="20" width="65"><STRONG>L-ID</STRONG></TD><TD class="xl70" style="border-left: none;" width="64"><STRONG>M-ID</STRONG></TD><TD class="xl70" style="border-left: none;" width="64"><STRONG>T-ID</STRONG></TD><TD class="xl71" style="border-left: none;" width="388"><STRONG>Process Flow</STRONG></TD></TR><TR><TD class="xl66" height="20" style="border-top: none;">A</TD><TD class="xl65" style="border-top: none; border-left: none;">B</TD><TD class="xl65" style="border-top: none; border-left: none;">C</TD><TD class="xl72" style="border-top: none; border-left: none;">RC1-RC1BOATA</TD></TR><TR><TD class="xl66" height="20" style="border-top: none;">A</TD><TD class="xl65" style="border-top: none; border-left: none;">B</TD><TD class="xl65" style="border-top: none; border-left: none;">C</TD><TD class="xl72" style="border-top: none; border-left: none;">RC1-RC1BOATB</TD></TR><TR><TD class="xl66" height="20" style="border-top: none;">A</TD><TD class="xl65" style="border-top: none; border-left: none;">B</TD><TD class="xl65" style="border-top: none; border-left: none;">C</TD><TD class="xl72" style="border-top: none; border-left: none;">RC2-RC1BOATA</TD></TR><TR><TD class="xl67" height="21" style="border-top: none;">A</TD><TD class="xl68" style="border-top: none; border-left: none;">B</TD><TD class="xl68" style="border-top: none; border-left: none;">C</TD><TD class="xl73" style="border-top: none; border-left: none;">RC2-RC1BOATB</TD></TR></TBODY></TABLE><P></P><P>Please help how to read in qlikview.</P><P></P><P>Thanks in Adnavce....</P><P></P><P></P><P>Regards,</P><P>Siri</P></BODY></HTML> Fri, 19 Oct 2012 12:38:44 GMT https://community.qlik.com/t5/QlikView/Read-Array-Type-Field-FieldList/m-p/433302#M699685 2012-10-19T12:38:44Z Re: Read Array Type Field -- FieldList https://community.qlik.com/t5/QlikView/Read-Array-Type-Field-FieldList/m-p/433303#M699686 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Can you share a .xls sample plz ?</P><P></P><P>I think you should use subfield() function to organize your data in the way you want</P></BODY></HTML> Fri, 19 Oct 2012 12:52:37 GMT https://community.qlik.com/t5/QlikView/Read-Array-Type-Field-FieldList/m-p/433303#M699686 christophebrault 2012-10-19T12:52:37Z Re: Read Array Type Field -- FieldList https://community.qlik.com/t5/QlikView/Read-Array-Type-Field-FieldList/m-p/433304#M699687 <HTML><HEAD></HEAD><BODY><P>HI</P><P></P><P> I think attached file help you..</P></BODY></HTML> Fri, 19 Oct 2012 13:01:46 GMT https://community.qlik.com/t5/QlikView/Read-Array-Type-Field-FieldList/m-p/433304#M699687 MayilVahanan 2012-10-19T13:01:46Z