Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
FelixEva
Contributor
Contributor

treplacelist missing letter after replacement

Hi there! I Hope u can help me as i don´t know what else i should do.

Problem is, that my data is running through "treplacelist" with a "tfileinput" external csv for matching and the input data is coming from the database. When the data is going through the treplacelist component the export csv always misses the letter "m".

Example:

input data "TrialMoodle" --> mapping with treplacelist "Moodle" (should be the output) --> output "oodle" (so the "m" is gone although the csv for matching contains the "m")

Hope u understand my problem. Thanks in advance!

Regards Felix

Labels (2)
5 Replies
Anonymous
Not applicable

Hello,

How did you set your "lookup search column" and "lookup replacement column"

Would you mind posting your tReplaceList component setting screenshot on community? Which will be helpful for us to address your issue.

Please mask your sensitive data as well.

Best regards

Sabrina

FelixEva
Contributor
Contributor
Author

0695b00000RiDwOAAV.png0695b00000RiDwiAAF.pngThanks for your answer. You mean with "posting on community" this thread, or where should I idealy post it?

 

Attached a screenshot from the excel tfileinput data and a screenshot from the tReplaceList component.

FelixEva
Contributor
Contributor
Author

Did u find out anything?

FelixEva
Contributor
Contributor
Author

?

Anonymous
Not applicable

Hello,

Sorry for delay. I haven't found any issue from your setting and I'm discussing this issue with my team to see if there is something missing.

Best regards

Sabrina