Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
CSmith1605109986
Contributor
Contributor

tMap expression help

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

Labels (3)
2 Replies
Anonymous
Not applicable

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

CSmith1605109986
Contributor
Contributor
Author

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.