Choose workflows

[AlyKnime]

I have this table of vendor/vendors to be used as a filter.

Vendor:

123456789
678901234

Output (A) is:
(LIFNR EQ ‘123456789’ OR
LIFNR EQ ‘678901234’)

But, what if I only have one vendor which is 123456789 and i need an output (B) of:
(LIFNR EQ ‘123456789’)

Can you help me to create a workflow that can choose whichever is needed? Like use this if it has only one line of vendor, and use this if two vendor, and use this if there are more than 2 vendor.

Thanks!

[Andrew_Steel]

Hi @AlyKnime,

this should work with 1-N Vendors:

Best regards
Andrew

BuildQuery.knwf (23.8 KB)

[Sajjadmosaheb]

Hi @AlyKnime,
In this case, you don’t need to split the data into one or more, you can easily use the @Andrew_Steel Solution, but I prepare an example of using IF Switch node for such situations:

if switch.knwf (18.3 KB)