Hi,
Is there a way to replicate below excel formula in Alteryx? I tried my best to use the filter and formula tool by using IF and CONTAINS function but nothing worked. Any help would be appreciated. Thank you in advance!
IF(COUNTIF(A$2:A$6,A2)>1,TRUE,FALSE)
Solved! Go to Solution.
Hi @aparna0208 sounds like you want to use a summazie tool then a formula tool to do an If to flag if its true or false. yOU Could just use a filter after the summaize tool as well.
Hi @aparna0208
The way you approach certain situations in Alteryx require a different mindset you're used to in Excel.
Here's what I'd do:
Use Summarize Tool to count the occurences of this cell, grouping by your A field;
Use IF Function to define TRUE or FALSE if that cell in specific has a count greater than 1;
Join the result back to your dataset by your A field if you need to repeat this value.
Cheers,
It worked! Thank you so much @JosephSerpis @Thableaus @jdunkerley79 for your inputs on this:)