topic Multiple Fields in Excel Sheet Columns (Attachment) in QlikView https://community.qlik.com/t5/QlikView/Multiple-Fields-in-Excel-Sheet-Columns-Attachment/m-p/920346#M985293 <HTML><HEAD></HEAD><BODY><P>Dealing with some tricky excel sheets.. As seen in the attachment, there are 2-3 rows of headers in each column. Notice also that there can be 3 lines given for style number - and I need to collect and concatenate them.</P><P></P><P>If I was able to get the full style number in the right place, I could probably do something like:</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if(mod(RowNo(),3) +1 = 3, &lt;Field&gt;)</P><P>to see the remainder /3...</P><P></P><P>Regardless, I am stumped.. Any help would be much appreciated.</P></BODY></HTML> Wed, 29 Jul 2015 14:03:45 GMT 2015-07-29T14:03:45Z Multiple Fields in Excel Sheet Columns (Attachment) https://community.qlik.com/t5/QlikView/Multiple-Fields-in-Excel-Sheet-Columns-Attachment/m-p/920346#M985293 <HTML><HEAD></HEAD><BODY><P>Dealing with some tricky excel sheets.. As seen in the attachment, there are 2-3 rows of headers in each column. Notice also that there can be 3 lines given for style number - and I need to collect and concatenate them.</P><P></P><P>If I was able to get the full style number in the right place, I could probably do something like:</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if(mod(RowNo(),3) +1 = 3, &lt;Field&gt;)</P><P>to see the remainder /3...</P><P></P><P>Regardless, I am stumped.. Any help would be much appreciated.</P></BODY></HTML> Wed, 29 Jul 2015 14:03:45 GMT https://community.qlik.com/t5/QlikView/Multiple-Fields-in-Excel-Sheet-Columns-Attachment/m-p/920346#M985293 2015-07-29T14:03:45Z