Welcome to the new General AFG Discussions board! For ADAPT questions, please check out our new ADAPT Discussions Board!

General AFG Discussions

The Alteryx For Good program is currently being updated to better reflect our organizational values. Please be on the lookout for news regarding our new community presence in the future.
SOLVED

How to build Mapping Vlook with Count Formula

Learner09
8 - Asteroid

Hi All,

I am trying to build a count formula by using mapping and current data sets. Please see the attached file for details and provide assistance.

 

Thanks, 

2 REPLIES 2
Jean-Balteryx
16 - Nebula
16 - Nebula

Hi @Learner09 ,

 

Here is an example workflow ! So basically a join between bot sheets allows you to know which ID are in Data and not in mapping. For those, you had a count of 1 and for ID in both sheets you had a count of 0 then using a union you assemble back the data.

 

Cheers,

 

Jean-Baptiste

Learner09
8 - Asteroid

Thanks Jean!