Hi guys,
I'm struggling to find a way to automate a random extract on a csv input.
Let me explain myself:
I have 2 columns :
- [Client ID] // is not à unique key
- [Client Comment]
I want to randomly select exactly 10[Client Comment] per [Client ID]
While it would be easy to radomly select X [Client Comment] , I can't find a way to add the variable "with exactly 10 [Client Comment] per [Client ID]".
Thank You in advance
Solved! Go to Solution.
Hi @max_hfr,
One option is to create a batch macro that read a list of client IDs, and then within the macro itself it selects random 10 comments (for each client ID that passes through the macro).
Karam
Thanks a lot!