Script Help

[Mahamed_Qlik]

Hi All,

I need help on help on the below scenario :

I have field named as "Name"

Name
1
2
3
John
Mark

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

Name
John
Mark

Kindly Help.

Regards,

Mahamed

[Anonymous]

may be like:

load *,

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

from tableName;

[arulsettu]

try this

PurgeChar(name,'0123456789') as new

[maxgro · Accepted solution]

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

load Name

Inline [

Name

1

2

3

John

Mark

Mark1

]

Where not IsNum(Name);

[tamilarasu]

Try,

Test:

LOAD FieldName

FROM

[Input.xlsx]

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

[tamilarasu]

Or

Where IsText(FieldName);

[Mahamed_Qlik]

Hey maxgro,

It works.! It is new for me

Thank you for the help.