cancel
Showing results for 
Search instead for 
Did you mean: 

how to retrieve odd or even rows from the table?

KHK
Ranger

Hi Team,

please let me know how to retrieve odd or even rows from the table?

Regards,

HK

3 REPLIES 3

RADSr
Partner
Partner

Can you give a bit more context?   Is this random?  Does it depend upon ordering by a specific field?

A use case example would be helpful to get you the correct and best answer.

HI ,

If i want only odd numbers then only odd number rows should  retrieve from table

Drag a formula into the individual filter area of an insight.   You can use the MOD function to determine odd/even  e.g. 

mod(Date_US.Date_US.Day_Number, 2) = 0
 
Result e.g.  
RADSr_0-1674314682898.png