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
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 ?
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.
@Learner09
Do you need to keep repeated IDs in Sheet 1 ?
