Load only every Nth Row

[luke1986]

Hello Folks,

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

So basically my sample data looks like this:

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

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

So the Output should look like this:

Rowno	Data
1	basdf
3	asdfgf
6	adrete
9	adsad
...

Thanks!

[kenphamvn]

Hi

Try this

Load *

From Table

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

[luke1986]

Thanks man, it worked! Didnt knew that function 🙂