Count workflow

Hi,

could someone please help me with my workflow? I have created a workflow, but I am not getting the desired results. Why doesn't the tool Formula in the column Check give a final count 6, instead of 2? Where is the issue? In the Key column, I have 6 identical results, is maybe the problem in the Data Type?

Worklow and Excel attached.

Count workflow.yxmd

export1.XLSX

Workflow

Error Message

Accepted answers

I would also add a group by Key and move it to the top. That way if you have multiple unique keys you get a count for each.

All comments

Kenda

Hi @denisstravs

In your workflow, you use the expression CountWords([Reference]). According to this article, CountWords() returns the count of words in the specified string. Words are defined by characters separated by a space.

In your Reference field, there are two sets of characters separated by a space which is why the Check expression is resulting in a 2.

geraldo

@denisstravs

I don't understand what you want to calculate.
you have 6 records that came from excel.
in the formula you calculate the number of words,

what do you really want

denisstravs

Hi, hmmm, okay, so this is totally wrong. I would like to calculate the total value of the identical keys. In this case, I expect in the column Check to show a total value of 6, since I have 6 identical keys. How can I generate this formula?

Kenda

@denisstravs

Try using the Summarize tool, adding a Group By & Count on your Key field.

jacobcarman

You could add a Summarize tool where you group by Key and count Key. That would give 6. You could then append/join that back to the records. If you just need to see how many identical keys, then no need to join it back.

geraldo

@jacobcarman

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703