Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Row contents count

iamthejedi
5 - Atom

I am working with data on Alteryx and I have hit a roadblock.

 

I have a list of assets and I have fields with various keywords. The "X" tags the asset descriptions that contain specific keywords of interest.

 

What I am looking to do at the end is to have a field for the count of "X" tags for each individual asset.

 

How would I go about this? 

 

Capture.PNG 

 
3 REPLIES 3
fmvizcaino
17 - Castor
17 - Castor

Hi @iamthejedi ,

 

Attached is an example workflow that does the job.

 

Let me know if that works for you.

 

Best,

Fernando V.

Kenda
16 - Nebula
16 - Nebula

Hi @iamthejedi 

 

I would recommend Transposing your data first! This will allow you to keep this solution for as many fields as you want going forward. Then, just filter out the empty ones, count the ones left, then join this back with your original data set.

 

Capture.PNG

iamthejedi
5 - Atom

Worked perfectly

Labels