3 Replies Latest reply: May 15, 2014 10:10 AM by elginreigner _ RSS

    MIN or MAX function on a External lookup?

    joe.lovati _

      I have a 1 to 1 relationship table (unique to a account number) and trying to do an external look up to another table (1 to many) that has transaction history for that account. I get an warning asking "do you want to continue using data from the first instance of each key?"  But what i'd like to do to link on the max or min value of say tran date in the "apply filter" section of the external lookup wizard.   Is this possible in monarch or should I start writing SQL?