4 Replies Latest reply: Dec 5, 2014 8:30 AM by Puttemans Johan RSS

    Select only 1 value out of a range for mapping purposes

    Puttemans Johan

      Hi there,

       

      I have a table out of which I'd like to create a mapping table. Problem is however that for now, there is no 1 to 1 mapping possible. For every 'identifier' in the table, there can be 1 or more MOAR's.

      As the information between MOARs is similar (result of a multiplication earlier on in the process which I cannot change), I can afford to drop them, and only keep 1 per identifier. My question now is how to reduce the MOAR's so that for every identifier, I only keep 1 MOAR out of 1/2/3/.....

       

      Thank you for the help