count of a specific string of all the rows in 1st column

akhi_shukla

Hello Experts, Could you Pls help me with the workflow options how to build my use case explained below.

I want to counts of Check and Match outcome of a validation from column B to H in first column A. In column A, I am looking how many Check and Match are there in that row from column B to H.

count of a specific string of all the rows in 1st column.xlsx

OTrieger

@akhi_shukla

Your data is coming in Excel so it is horizontally and you would like it to be vertically, as Alteryx is defining the data based on Columns (fields).

There are 2 Tools that handling horizontal/vertical data, Cross-Tab and Transpose. Go and check how they are working, now that you managed to figure out how to flip the data, you can use Summarise Tool to do the counting. You just need to group the data in the way that it will give you the correct count.

So if you are not familiar with these tools, there is some learning for you to do on the Interactive Lessons in Alteryx Academy.