topic Re: Load only every Nth Row in QlikView https://community.qlik.com/t5/QlikView/Load-only-every-Nth-Row/m-p/1426698#M611099 <HTML><HEAD></HEAD><BODY><P>Thanks man, it worked! Didnt knew that function <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span> </P></BODY></HTML> Tue, 07 Nov 2017 10:41:22 GMT luke1986 2017-11-07T10:41:22Z Load only every Nth Row https://community.qlik.com/t5/QlikView/Load-only-every-Nth-Row/m-p/1426696#M611097 <HTML><HEAD></HEAD><BODY><P>Hello Folks, </P><P></P><P>I am struggling with a dataset but couldnt find any easy/quick solution.</P><P></P><P>So basically my sample data looks like this:</P><P></P><TABLE border="1" class="jiveBorder" height="249" style="border: 1px solid rgb(0, 0, 0); width: 320px; height: 235px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Rowno</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Data</STRONG></TH></TR><TR><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">basdf</TD></TR><TR><TD style="padding: 2px;">2</TD><TD style="padding: 2px;">asdfg</TD></TR><TR><TD style="padding: 2px;">3</TD><TD style="padding: 2px;">asdfgf</TD></TR><TR><TD style="padding: 2px;">4</TD><TD style="padding: 2px;">adgfd</TD></TR><TR><TD style="padding: 2px;">5</TD><TD style="padding: 2px;">adad</TD></TR><TR><TD style="padding: 2px;">6</TD><TD style="padding: 2px;">adrete</TD></TR><TR><TD style="padding: 2px;">7</TD><TD style="padding: 2px;">adads</TD></TR><TR><TD style="padding: 2px;">8</TD><TD style="padding: 2px;">adsad</TD></TR><TR><TD style="padding: 2px;">9</TD><TD style="padding: 2px;">adsad</TD></TR><TR><TD>....</TD><TD></TD></TR></TBODY></TABLE><P></P><P>After loading the first Row, I only want to load every third Row in Code</P><P></P><P>So the Output should look like this:</P><P></P><P></P><TABLE border="1" class="jiveBorder" height="99" style="border: 1px solid rgb(0, 0, 0); width: 313px; height: 97px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><SPAN style="color: #ffffff; font-size: 13.3333px; text-align: center; background-color: #6690bc;">Rowno</SPAN></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG style="color: #ffffff; font-size: 13.3333px; text-align: center;">Data</STRONG></TH></TR><TR><TD style="padding: 2px;">1</TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">basdf</SPAN></TD></TR><TR><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">3</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">asdfgf</SPAN></TD></TR><TR><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">6</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">adrete</SPAN></TD></TR><TR><TD><SPAN style="font-size: 13.3333px;">9</SPAN></TD><TD><SPAN style="font-size: 13.3333px;">adsad</SPAN></TD></TR><TR><TD>...</TD><TD></TD></TR></TBODY></TABLE><P></P><P>Thanks!</P></BODY></HTML> Tue, 07 Nov 2017 10:24:49 GMT https://community.qlik.com/t5/QlikView/Load-only-every-Nth-Row/m-p/1426696#M611097 luke1986 2017-11-07T10:24:49Z Re: Load only every Nth Row https://community.qlik.com/t5/QlikView/Load-only-every-Nth-Row/m-p/1426697#M611098 <HTML><HEAD></HEAD><BODY><P>Hi </P><P>Try this</P><P>Load *</P><P>From Table</P><P>where rowno =1 or mod(<SPAN style="font-size: 13.3333px;">rowno,3) =0</SPAN></P></BODY></HTML> Tue, 07 Nov 2017 10:35:56 GMT https://community.qlik.com/t5/QlikView/Load-only-every-Nth-Row/m-p/1426697#M611098 kenphamvn 2017-11-07T10:35:56Z Re: Load only every Nth Row https://community.qlik.com/t5/QlikView/Load-only-every-Nth-Row/m-p/1426698#M611099 <HTML><HEAD></HEAD><BODY><P>Thanks man, it worked! Didnt knew that function <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span> </P></BODY></HTML> Tue, 07 Nov 2017 10:41:22 GMT https://community.qlik.com/t5/QlikView/Load-only-every-Nth-Row/m-p/1426698#M611099 luke1986 2017-11-07T10:41:22Z