Router configuration

[sanam]

Hi Team,

I need some help in router configuration.
I have snap execute where we select data and want to push to different target tables based on theater column.
how to put the condition
theater=‘America’ in the router.

[tlikarish]

The = next to the expression will toggle it on and off. When it’s light gray that means it will treat the value as a String. Can you toggle it back on and try that?

[sanam]

it gives same error for both options

[tlikarish]

Try playing around with this example to see if it helps you figure out the problem.

router-example_2019_08_29.slp (3.9 KB)

[sanam]

Thanks tilkarish for helping.

I was able to get it by using select instead of execute snap.
I want to know if the query in in sql execute how can we get the column recognized in router.

[lokey]

@sanam If you are using execute snap use $.count <= 0