If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
I have the data in below format.
I need to remove all values for the field Field0_Pers.area which starts with the *.
Do you want to remove the "*" prefix from the field value:
Or do you want to exclude the records where there is "*" prefix:
LOAD Field0_Pers.area,....From ....Where Left(Field0_Pers.area, 1) <> '*';
View solution in original post
Is the field always in this condition? If the answer is yes, use the most simplest version:
If your field PAXXX varies in length use:
Thanks a lot Jontydkpi.