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]

Use two equals signs to do an equality comparison.

theater=='America'

[sanam]

It is throwing Error in router . I have a select query in sql server execute

[sanam]

when i dont add the $ sign
record_count is undefined. Perhaps you meant: parseInt, decodeURIComponent, parseFloat, encodeURIComponent, Resolution: Please check the spelling of the variable

[tlikarish]

The $ refers to the incoming document. The error message means that one (or more) of the incoming documents doesn’t have a field called record_count. Could you look at your pipeline’s preview data and see if that field exists?