Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
ApplyMap does this automatically. If it encounters multiple MOARS per identifier, it will only keep the first (or the last...) it encounters.
Easily done but what should be the logic? which MOAR would you choose if you have 3 per identifier? The first encountered? or?
Hello Ioannis,
yes, the first encountered would be fine. That doesn't really matter.
Regards,
Johan
ApplyMap does this automatically. If it encounters multiple MOARS per identifier, it will only keep the first (or the last...) it encounters.
Hello Ioannis,
Thank you for pointing out. It works as wanted now. Thank you.