Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I am trying to implement some SQL code in the tMap expression editor.
in.ReportPath.Right(ReportPath,Charindex('/',Reverse(ReportPath))-1)
The SQL is:
Right(ReportPath , Charindex ('/' ,Reverse(ReportPath))-1) where it deletes the first part of a path from incoming by removing everything before the last backslash in the URL.
It won't compile complaining that ReportPath cannot be resolved to a variable.
Does anyone have a suggestion on how to get it working?
Thanks
Chris
Hello,
We are supposing that how you have configured wrong.
Make sure that you are not missing the quotation marks if needed.
Best regards
Sabrina
I ended up putting the code in the select statement of the tMSSqlinput.
I couldn't figure out the correct syntax to have it in the tMap expression.