Hello All,
I am trying to build an Alteryx flow for Unique count with Vlook mapping condition but unable to design the correct flow. Please help.
See the attached excel for details.
Solved! Go to Solution.
Hi @Learner09 ,
I don't get what you want to do. You want to count the number of times an ID appears ?
Cheers,
Jean-Baptiste
Hi. Can you explain below what exactly you doing? Why some are 1 but others ZERO?
I am not able to understand why the 3 of the ID 6149401 is 1 but all others are ZERO?
I am not able to understand why the last one for ID 6105297 is 1 but all previous are ZERO?
=COUNTIF(Where do you want to look?, What do you want to look for?)
What exactly you trying to achieve by using the COUNTIF? Why you using the next row element for the current row in COUNTIF for "What do you want to look for?"?
I am trying to achieve a unique customer count on the basis of ID. I have Historical Mapping "tab 2014". So condition, first we need to check/search/lookup ID into Historical Mapping tab "2014", if it is equal to 0 then just simply count in the ID population only from top to bottom and then if this condition greater than 1 then 1 otherwise 0. So also see the formulae in the customer count column.
Thanks
Please see the attached file
Hi @Learner09 ,
So you have a list of ID in Sheet 1 and another list of ID in 2014 an you want to tag IDs that aren't in 2014 in Sheet 1 ?
Cheers,
Jean-Baptiste
Correct, but in Sheet 1 - ID should count as unique or single time. e.g. if the ID appears in 4 lines then it should count 1 on one line and rest three lines should be 0.
that will be easy to do if "Not in 2014 that why count as 1, as a unique"