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.

[sanam]

Thanks for replying.
below is my pipeline
and in the sql execute i have select count(1) as record count from table A.
I cannot preview the data.
I want to send email only if the record_count>1

record_count is undefined. Perhaps you meant: parseInt, decodeURIComponent, parseFloat, encodeURIComponent

Resolution:
Please check the spelling of the variable

[tlikarish]

Do you mind showing me how you have the SQL Server - Execute snap configured? The way you wrote your SQL the column name is record count (with a space), but in your expression you use record_count (with an underscore). Maybe there is some difference there.

[sanam]

[tlikarish]

Fields are case-sensitive, so try the expression in your Router without a capital ‘R’ for $Record_count. Also, I believe the return type of count is int, so you shouldn’t need quotes around the zero either.

$record_count == 0

[sanam]

I did match the case but got below error
Router expression $record_count==0 did not evaluate to a boolean value. Instead got type: String

Resolution:

Please address the reported issue.