Count Rows of each / specific unionized Table Records

Hi all,

I have an unionized Table meaning the records representing each table:

-->

I want to count the number of rows of each table. The summarize tool gives me only the option to count the number of records but I want to go one step deeper. Is there a possibility to do this? Please see the attached testing workflow.

Thank you
Marvin

test_countrow.yxmd

Data Investigation

Accepted answers

afv2688

Hello @MarvMaster,

I am not sure if it is possible to do after the table tool.

You could use the test tool to check the data before it goes into the table to match==> input = all outputs.

Regards

All comments

afv2688

Hello @MarvMaster,

could you please explain what you mean with one step deeper?

Regards

MarvMaster

When I just use the summarize / count tool, I will get "2" since I got for the -Union- tool two tables (each represents a record, as you can see on the first screenshot).

What I want is to count the content of the two tables, thats what you can see on the second screenshot. So a "5" and "6" or 11 combined is the desired outcome. Unfortunately I don't know how to do this.

Thank you for your reply!

Marvin

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703