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.
@Learner09 ,
Here is an attempt, tell me if it's what you are looking for.
Cheers,
Jean-Baptiste
Hi @Learner09 ,
I don't get what you want to do. You want to count the number of times an ID appears ?
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?"?
@Jean-Balteryx
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
@chinu267
