topic Re: tell me bellow req? in QlikView

tell me bellow req?

gkcchowdary — Mon, 24 Aug 2015 13:04:52 GMT

i have one filed ,so my data is

load * inline [

data

123

abc

11ab

23ac

];

my req:

once reload i want display only numaric value i'e 123 and second time display text and one more is only text and numaric

so total one time 123

second time abc

next 11ab and 23ac

how?

Re: tell me bellow req?

marcus_sommer — Mon, 24 Aug 2015 13:12:10 GMT

You could create a type-state for your field, like:

load *, if(isnum(data), 'numeric', if(len(keepchar(data, '0123456789'))>=1, 'mixed', 'pure text')) as [data-type];

load * inline [

data

123

abc

11ab

23ac

];

- Marcus

Re: tell me bellow req?

sasiparupudi1 — Mon, 24 Aug 2015 13:57:16 GMT

Please Try

temp:

load * inline

[

Data

123

abc

11ab

23ac

];

NoConcatenate

Numeric:

LOAD Data as NumericData Resident temp where IsNum(num(Data))=-1 ;

NoConcatenate

alpha:

LOAD Data as AlphaNumeric Resident temp where IsNum(num(Data))<>-1 and PurgeChar(lower(Data),'abcdefghijklmnopqrstuvwxyz')<>'' ;

NoConcatenate

text:

LOAD Data as TextData Resident temp where len(PurgeChar(lower(Data),'abcdefghijklmnopqrstuvwxyz'))=0;

drop Table temp;