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

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Avoid special characters on tmap

Hi,

 

I have been trying to avoid the special character like 312328-342344 ("-") and have output as 312328342344 or even 312328 342344  but it is not happening. Can you please help me on this. I did try the following;

row2.ColumnName.replaceAll("[-]", "")  and more but it doesn't work, I keep getting error. This has a data type string by the way. Can somebody help on this?

Labels (2)
20 Replies
Anonymous
Not applicable
Author

Hi, I tried your logic in tMap but it doesn't seem it is working.

I am trying to avoid "-" from AdminPartyId and only want those values given for AdminSystemValue. I can get those values on AdminSystemValue with the logic I have but never for AdminPartyId.

Anonymous
Not applicable
Author

You need to give a bit more information. What exactly did you try (ie show the code....copy and paste it here)? What was the error message?

Anonymous
Not applicable
Author

Hi, Please forget about the other filters. Now I only have

row2.AdminPartyId.replaceAll("[-]","")

Could you please help me getting rid of "-" character from AdminPartyId?

Anonymous
Not applicable
Author

That should work. The only thing you are possibly missing is a check for null. Are you getting any errors or is it just not removing the "-"? Can you show how this is used in your tMap? A screenshot of your complete tMap may help

Anonymous
Not applicable
Author

Hi, I am getting error with just the filter (

row2.AdminPartyId.replaceAll("[-]","") )

 and below is the error message;

Error Line: 3791

Detail Message: Type mismatch: cannot convert from String to boolean

 

Anonymous
Not applicable
Author

Can you please take a screenshot of your tMap? You are leaving out important information. The error...

Type mismatch: cannot convert from String to boolean

....suggests that you are trying to set a boolean value with a String. This suggests to me that either you are setting an incorrect column type OR you are using that logic in a filter. I cannot tell when you post your code. It MUST be a screenshot.

Anonymous
Not applicable
Author

Hi,

Attaching the screenshot. Please let me know if any questions.


tmapeg.JPG
vboppudi
Partner - Creator III
Partner - Creator III

Hi,

Are you using replace function in filter ? if yes then what are you trying to get out put?

You can use variable ports in tMap to clean data first then use that variable port in filter.

 

Regards,

 

 

Anonymous
Not applicable
Author

I was trying with replaceAll function to avoid "-". So you think I need to do on Variable ports? Could you please suggest me exactly what I need to mention as expression?

 

vboppudi
Partner - Creator III
Partner - Creator III

try this

0683p000009LtZ3.png

Regards,