Hello All,
On the input data tool I'm trying to connect to an SAP HANA view that has an 'active_or_historical' variable. When I run it I get a syntax error.
It's an ODBC connection.
I've been able to write for placeholders regarding dates but for $$Active_Or_Historical$$, I can't figure it out. I believe that it directs to a 'active table' if I indicate with an A or 'historical table' with an H.
FROM
“Schema” . "View” ( 'PLACEHOLDER' = ('$$Active_Or_Historical$$', '''A''')
I've used a variety of single and double quotes. I've moved the '=' and I've tried a bunch of other adjustments. I've searched on the community and have tried the answers provided but nothing works.
Does anyone else have an $$active_or_historical$$ variable on their HANA view? Any recommendations?
Thank you
Carmen
