Table name in SQL select snap
Hi, I have few tables on SQL server like
abc_2020
abc_2019
abc_2018
I want to query the the table that has suffix as current year. I have specified the value
in the settings > table name-- ...
Forum Discussion
HI @ksalem,
You can build a mechanism that will check for existing documents, by using the Gate snap.
The Gate Snap will move the pipeline flow even if no documents are provided on the input. From there you can simply add a router that will check for documents (Ex. $input.lenght == 0) and throw an error by using the Exit snap.
Hope this helps,
Bojan
See Reserved Groups on https://docs-snaplogic.atlassian.net/wiki/spaces/SD/pages/1438157/Groups
Thank you so very much Diane! This is what I was looking for
Best regards,
Andre
