Table validator ... for rows

[TigerCole]

Hi,

I get an export from a 3rd party system that I cannot change, so I need to validate it in KNIME.

I need to make sure that each site has a row for each day of the week. As in the screenshot, SiteA is correct but Site B and Site C are missing rows.

I am sure that there is a simple logical way to resolve this but I am not finding it. I would appreciate any suggestions.

Thanks.

tC/.

[ipazin]

Hello @TigerCole,

unique count per Group in GroupBy node? Or Pivoting if you add DoW as pivot. Pivoting will give you which Site is missing which day. Then you can even do Unpivoting to get missing rows. See this example:

Adding Missing Records – ipazin

Br,
Ivan

[duristef]

hi @TigerCole
this is my example data table

Using this workflow

I get this result

KNIME_project8.knwf (13.5 KB)

[badger101]

Lots of ways to get creative

Here’s my take on this:

Validate Days of the Week.knwf (35.5 KB)

Results:

[TigerCole]

Hi @badger101 …

I liked your suggestion, but I need to retain the day order. In your solution Site C has Friday and Sunday in the same row which would through the maths out downstream in the flow.

tC/.

[badger101]

Hi @TigerCole I personally like the workflow suggested by @ipazin , better than my own. You should have a look at it and the output that it gives. (I haven’t opened @duristef 's suggestion cause some of my nodes are similar to them) but the one by @ipazin is super simple.

[Daniel_Weikert]

Do a groupby and count the weekday column. If it is less then 7 you got the missing ones