Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Hi
Try this
Load *
From Table
where rowno =1 or mod(rowno,3) =0
Thanks man, it worked! Didnt knew that function 🙂