topic Re: Script Help in QlikView

Script Help

Mahamed_Qlik — Wed, 30 Dec 2015 07:16:46 GMT

Hi All,

I need help on help on the below scenario :

I have field named as "Name"

I need the column Name as only Names in it in script such as :

Name
John
Mark

Kindly Help.

Regards,

Mahamed

Anonymous — Wed, 30 Dec 2015 07:20:01 GMT

may be like:

load *,

if(len(Name)>1, Name) as Name

from tableName;

arulsettu — Wed, 30 Dec 2015 07:20:40 GMT

try this

PurgeChar(name,'0123456789') as new

maxgro — Wed, 30 Dec 2015 07:23:20 GMT

you can check for number and exclude the field (bold)

load Name

Inline [

Name

John

Mark

Mark1

]

Where not IsNum(Name);

tamilarasu — Wed, 30 Dec 2015 07:26:06 GMT

Try,

Test:

LOAD FieldName

FROM

[Input.xlsx]

(ooxml, embedded labels, table is Target) where Not IsNum(FieldName);

tamilarasu — Wed, 30 Dec 2015 07:28:57 GMT

Where IsText(FieldName);

Mahamed_Qlik — Wed, 30 Dec 2015 07:29:02 GMT

Hey maxgro,

It works.! It is new for me

Thank you for the help.