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.
Why ID 6171787 is counted as 1 twice then?
As you said for all others that are not in sheet 2014 "if the ID appears in MULTIPLE lines then it should count 1 on one line and rest three lines should be 0."
Hi @chinu267
This is the sample data that I shared and if you closely look at the formula then you found formula slipped by one row and rest other lines formula doing fine that the reason first 2 lines have 1,
Basic is that we need to look ID in Mapping 2014 first, to check further it is there or not, if not then we need to count in the Data itself but as unique.
Thanks,
Mayank
