Filter data using multiple selection widget and reference row filter

I am trying to create filter so that that user can select filter value and i have created that but if user do not select any value it should go all the values but it is giving blank table after after the filter. any suggestion

Hey there and welcome to the forum,

if you want that all rows are shown when the user selects nothing as well as when the user selects everything you’ll need a construct using empty table switch:

If table is empty we convert bottom branch to variable and connect that to a “pass through” node - in this case column expressions, which connects to bottom port of End If.

If table is not empty then the filtered table goes to upper port of end if.

Workflow:
refRowFilter.knwf (86.1 KB)

2 Likes

Thank You So much Martin :slightly_smiling_face:

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.