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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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​