Hi all,
I managed to use a Manual query inside my TDBInput, like this:
"SELECT
DISTINCT col1
'"+globalMap.get("start_dt")+"' as start_date
FROM table1;"
The problem is when I try to the same but by reading it from a file with tFileInputRaw->TFlowToterate->TDBinput with
globalMap.get("row2.content") inside. The globalMap doesn't get solved at runtime because it's inside a Java string. I've tried to escape it, done lots of single and double quotes combinations, but can't seem to find a way of this to work. It's just the globalMap that it's not being translated, since the query runs smoothly in the database.
How can I workaround reading from SQL file, when my SQL text contains globalMap inside?
My SQL file is the same as the above SQL but without the leading double quotes. Still, doesn't work.
