Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Our May 2021 end-to-end product release from Data Integration to Data Analytics is out! READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
hammermill21
Creator III
Creator III

Removing Any Number ending in _R from data in a Dimension

Hello!

I have a dimension of barcode_numbers, but I want to remove any numbers that end in _R and I'm not sure how to do that within a dimension. 

Any ideas?

Thank you 🙂 

Labels (2)
1 Reply
Lisa_P
Employee
Employee

If this is unique combination of characters you could use replace() function to replace '_R' with ''.
Best done in the load script eg
load ...
replace(barcode_numbers, '_R', '') as barcode_numbers
..