This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Find answers, ask questions, and share expertise about Alteryx Designer.
General Discussions has some can't miss conversations going on right now! From conversations about automation to sharing your favorite Alteryx memes, there's something for everyone. Make it part of your community routine!
I want group the records by "Key" and check if the grouped records have Type (101 or 102) and (45 or 46). If the group has either of those types then, select that group of records. In the e.g. shown K2 will be eliminated by this process
Next step is to apply formulas to the grouped subset.
E.g. Want to group by "Key" and apply formula to modify status -
You can solve this within the formula tool using conditional logic. Below is an example, but you can build it out for your use-case.
Another option is to use the initial logic (Key = 'K1' AND Type In (101, 45, ...) and apply the formula logic after that. If needed, you could even union the filtered out dataset back after you apply the formula.
I create a simple workflow that is fairly rough. You could probably reach the same endpoint with fewer tools but this is how I thought to do it. I hope this helps and feel free to ask any questions you have on it.
I abbreviated the data to only the columns that mattered for this question. I am first manipulating the data by changing the 102 and 46 to 101 and 45 because they are roughly the same for the desired checking and make the sorting formulas easier. Then I just check which keys do indeed match both and filter out the keys that don't using the join then just sort and add the status column.