Hi ,
I would like build a section for cross product check but within the same user. With this workflow, I may find out the user who has been enabled or not enable on certain products.
I have already had a simple one, but I am not satisfied with the solution, since it may contain the duplicate result. e.g.: If there are two enabled products under one user, it will generate one extra rows for the not enabled product. I am seeking your help to create a new flow or improve my flow in order to get the perfect answer that:
Even if one user has been enabled 3 products, and has 2 not enabled products, the i only get two rows of data not 6 rows. Thank you
Sample data
Firm | Product | Status | User |
A | Apple | Enabled | Amy |
A | Apple | Enabled | Ben |
A | Apple | Not Enabled | Cindy |
A | Banana | Enabled | Amy |
A | Banana | Not Enabled | Ben |
A | Banana | Not Enabled | Cindy |
A | Cheery | Not Enabled | Amy |
A | Cheery | Not Enabled | Ben |
A | Cheery | Not Enabled | Cindy |
B | Apple | Enabled | Dav |
B | Apple | Enabled | Eas |
B | Apple | Enabled | Fra |
B | Banana | Enabled | Dav |
B | Banana | Enabled | Eas |
B | Banana | Not Enabled | Fra |
B | Cheery | Enabled | Dav |
B | Cheery | Not Enabled | Eas |
B | Cheery | Not Enabled | Fra |
Output Data:
Firm | Product | Status | User | Right_Product | Right_Status | Right_User |
A | Banana | Not Enabled | Ben | Apple | Enabled | Ben |
A | Cheery | Not Enabled | Amy | Apple | Enabled | Amy |
A | Cheery | Not Enabled | Ben | Apple | Enabled | Ben |
B | Banana | Not Enabled | Fra | Apple | Enabled | Fra |
B | Cheery | Not Enabled | Eas | Apple | Enabled | Eas |
B | Cheery | Not Enabled | Fra | Apple | Enabled | Fra |
Solved! Go to Solution.
Hi @k3pineapple Please have a look if this works for you.
Here workflow joins 'not enabled' and 'enabled' rows and after deletes extra rows based on values in 'not enabled' part.