Hello,
I am using Sample Tool to get the N number of Products for Each Category .
Is there anyway to Get N number of records in each category based on Some condition.
Example
If Category is 'A' or Category is 'B' then Get 10 Products for this category
Else Get 5 Products for remaining Categories.
Data: (2 Columns)
CategoryName
ProductName
Solved! Go to Solution.
Hello @tjamal1 ,
I have created a little workflow that should fill your request 🙂
If you need anything else let me know 🙂
@afv2688 Thank you for your workflow. It helped.
I have one question, If my Column Names will change in the table and I add more columns to my table, Will it affect the Macro you designed and will it needs to be changed?
Hello @tjamal1 ,
the workflow uses the "Category" column to do the counting and the sampling, you could either have the column renamed before entering into the treatment performed or edit the macro to match your column name, as you wish 🙂
Regarding your second point, you can add as many columns as you like, it shold not be affected.
Regards