accessing a particular row in a data set

lektuvaslektuvas Junior Member
edited December 31, 1969 in Designing Analytics Reports
Hello,

I have SQL query that returns exactly 8 rows. I want to use a column of the 3rd row of this data set. Is there a way to access a specified row?

Comments

  • VirgilVirgil Administrator EM admin
    edited December 31, 1969
    There might be more ways to do this but here is one way.

    Add a table (or list) to the report.
    Select the table, and then the Filters tab in the Property Editor
    Add a filter of:

    Expression: row[0]
    Operator: Equal to
    Value: 2 --- (This should return the 3rd row since rows are zero based)

    Oh yeah, then add the column you want to the table's detail section.

    Virgil

    Virgil Dodson
    OpenText Analytics Developer Community
    https://forums.opentext.com/forums/categories/analytics

Sign In or Register to comment.