Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Record function can be written in a file of /resource used by the Miscellaneous Functions runtime:loadResource

Hi, Is it possible a Record function can be written in a file of /resource used by the Miscellaneous Functions runtime:loadResource? Like in the file /home/user/streamsets-datacollector-3.4.0/resources/mytest.txt, I write a sql with a record function,

SELECT id FROM dbo.xxxxxx WHERE id = ${record:value('/productid')}

I got a sql syntax error when I preview, looks like ${record:value('/productid')} are not explained . Thanks.