Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
stephbzr
Contributor III
Contributor III

tSampleRow

Hello, 

I would like to use the tSampleRow component, but it requires a precise position of rows to extract. I would just like to tell it to take from the second to the last row.

For example, I have x lines (a file-dependent value) and I only want from line 2 to line x. 

Labels (4)
1 Solution

Accepted Solutions
Anonymous
Not applicable

Just set a very big number that you think the number of lines will not reach?

eg:

"2..1000000"

View solution in original post

2 Replies
Anonymous
Not applicable

Just set a very big number that you think the number of lines will not reach?

eg:

"2..1000000"

stephbzr
Contributor III
Contributor III
Author

Yes it's not a bad idea as I don't work with big data

But if there are other techniques with this component, I'm interested

I tested this, but I knew it wouldn't work

0695b00000UyJoFAAV.pngThanks @Shicong Hong​