Hi Brian,
I´m sure you can help me with this.
Have a list of payments to vendors made by users and I would like to extract vendors who have been paid by only one user.
Any simple way to do this in Idea?
Thank you in advance.
Fernando
yongest
Offline
Last seen: 6 years 1 month ago
Joined: 04/04/2014 - 07:40
Hi Fernando,
Yes there is an easy, you can actually use Duplicate Key Detection to do this. So your key would be vendors and users but in the dialog select "Output Records Without Duplicates", this will extract all the single vendor / users payments.
Another way is to do a summarization by Vendor and User and then extract all transactions that only has 1 as the number of records.
Hope this helps and what you are looking for. If not let me know.
Brian
Hi Brian,
Thank you very much for your help!
I had to summarize twice and I think it worked. I´m not sure it is the most streamlined approach but kind of work
I think that my question was not very well explained. What I´m trying to find from that payments file is the case that "user 1" creates a bogus vendor, I´m assuming that only "user 1" is the only user paying to that vendor. That is why I am trying to extract vendors that have been paid only by one user.
The file has thousands of payments (made by thousand of users to thousand of vendors), so using "duplicate key detection" extract too many false positives. Same with summarization and extract.
I summarize by vendor and user and then taking the output file, summarize by vendor again. Those with 1 record are the ones I´m looking for.
Anyhow I´m not very satisfied with the solution, specially since I´m losing a lot of info from the original fil. If you can think of a nicer solution with "duplicate key" or something like that, please let me know.
Thank you again for your quick reply.
Regards.
Fernando
Hi Fernando,
Thanks for the clarrification. That is how you do it, you have to do the summary twice and then extract those with one record.
Good luck with your analysis.
Brian
Thank you Brian, and congratulations for your website, it´s really helpful.
Hello Fernando,
If I understand your explanation of the data correctly, I think the Duplicate Key Detection "Output Records without Duplicates" will work if your choose both of your key fields: User and Vendor.
You are able to use up to 8 key fields in a duplicate key detection.
Let me know if that works for you.
Cheers,
Steve