My requirement is to pull data only for few Markets and I don't want to hardcode the values in Where condition. So, I created a variable like below using Chr(39) which should populate single quote in output. However, I am observing double quotes in output.
Just now I noticed that it is working fine when I am directly loading in QlikView file. But when I trying same in below procedure it is giving wrong output.
In QVD Generator, for SQL query I need to apply this where Condition. For the same, I created an include script file and created a variable as above and in Generator SQL query I written where condition as MARKET IN '$(vVariableTest )' which is giving double quotes when I am checking log files.
PS: I cannot share sample file for now, I will try to create one.