topic Re: Remove Records in QlikView

Remove Records

gautik92 — Wed, 25 Nov 2020 16:16:04 GMT

I have a table with records containing alphabets and numbers but i want to remove the records whic contain alphabets.

101/001

101/002

UPAXY

NFKAO

MAJFJF

I have to remove the records which contain alphabets

sunny_talwar — Mon, 02 May 2016 06:24:02 GMT

May be this in the where clause

LOAD FieldName

FROM Source

Where Len(Trim(KeepChar(Upper(FieldName), 'ABCDEFGHIJKLMNOPQRSTUVWXYZ'))) = 0;

UPDATE: Sample attached

ajsjoshua — Mon, 02 May 2016 06:27:25 GMT

Hi Bro,

Try

keepchar(FIELD, '/0123456789') as NEWFIELD

in your load or equivalent in an expression.

tamilarasu — Mon, 02 May 2016 06:39:05 GMT

Hi Bro,

If the field values are fully text or number, then you can try like below,

If(Isnum(Left(FieldName,1)),FieldName) as FieldName

Where Isnum(Left(FieldName,1))= -1