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.
Yes, Actually I have 20k+ lines data for these IDs and all data required for reporting purposes, so I need all repeated ID.
Thanks,
Mayank
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
Looks good to me. Only Mayank can confirm whether we understood him or not:-)