Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

luke1986
New Contributor III

Load only every Nth Row

Hello Folks,

I am struggling with a dataset but couldnt find any easy/quick solution.

So basically my sample data looks like this:

RownoData
1basdf
2asdfg
3asdfgf
4adgfd
5adad
6adrete
7adads
8adsad
9adsad
....

After loading the first Row, I only want to load every third Row in Code

So the Output should look like this:

RownoData
1basdf
3asdfgf
6adrete
9adsad
...

Thanks!

2 Replies
kenphamvn
Contributor III

Re: Load only every Nth Row

Hi

Try this

Load *

From Table

where rowno =1 or mod(rowno,3) =0

luke1986
New Contributor III

Re: Load only every Nth Row

Thanks man, it worked! Didnt knew that function :-)

Community Browser