Discussion board where members can get started with Qlik Sense.
I have the data in below format.
I need to remove all values for the field Field0_Pers.area which starts with the *.
Go to Solution.
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) <> '*';
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.