arvindnsn
2 years agoContributor
Route object value from a list of values
Hello,
I have a Snowflake select Snap that outputs values of "ABC", "AEC", "ANC", "ABK", "AMT", "AGT". I have the output stored in a mapper variable called "src_name". In the next Router Snap, I have 2 outputs that routes based on the below condition.
$src_name in ('ABC', 'AEC', AMT') and $src_name in ('ANC', 'ABK', AGT'). I am trying to use Map function to achieve this but not able to.
Any help would be appreciated.
Hi @Sahil ,
With this expression in mapper, you can get the IDs:
With this expression in mapper, you can get the Headers:
Let me know if this helps you.
BR,
Marjan