Skip to Content
avatar image
Former Member

co-related sub-query

Hi Gurus,

In SQL I can easily create a co-related sub query, to return the maximum User_Id in each Department.

Can I do the same in an attribute view?

I tried by adding Max(User) id as a calculated field and Department as a regular field. This gave an error on activation. How do I tell an attribute view to do the equivalent of group by on the Department?

Thanks

Cliff

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Sep 18, 2014 at 12:25 PM

    Hi Cliff,

    I think you can do this with analytic view instead of attribute view.

    Best regards,

    Wenjun

    Add comment
    10|10000 characters needed characters exceeded