0

How do I get nth row from a table?

Rana Mohsin Shakoor Manj

March 13, 2019 22:47

Answered

Follow

Hi,

 

Can someone please tell me how can I get the nth row in Jet Reports?

I have tried using "LIMIT=", but it is not working. I am using the following query to get the 'Value Code' from 2nd row only using the query as following:

 

=NL("Last","Item Marketing Category Value","Value Code","Category Code","APPLICATION","Item No.","SCARLET792","LIMIT=",2)

 

But this is returning only last row. Please help me and tell me what query can I use to get just the 2nd row values?

• Facebook
• Twitter
• LinkedIn

2 comments

• 1
  
  Harry Lewis March 14, 2019 00:24

  Hello Rana -

  You use your N as the WHAT parameter in the function:

  For example...

  If I wanted the name of the 5th customer from the Customer table:

  =NL("5","Customer","Name")

   

   

• 0
  
  Rana Mohsin Shakoor Manj March 14, 2019 00:37

  Hi Harry,

  You're a legend. Thanks, that worked for me.

  Regards

  Rana Mohsin Shakoor Manj