Alteryx designer Discussions

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

Row contents count

Highlighted

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 

 
Highlighted
Alteryx Certified Partner

Hi @iamthejedi ,

 

Attached is an example workflow that does the job.

 

Let me know if that works for you.

 

Best,

Fernando V.

Magnetar
Magnetar

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

Highlighted

Worked perfectly

Labels