using CAT in a subquery

Comments

2 comments

  • Avatar
    Alex Pooley

    Lookup only supports returning one row, where as I need to return all rows that match the dept, hence using cat.

    0
    Comment actions Permalink
  • Avatar
    Alex Pooley

    I guess one option is a very long label value pairs string in the parameter but I would have to duplicate this across many panels so updating would be a nightmare.

    0
    Comment actions Permalink

Please sign in to leave a comment.