topic Re: I have one table ? in QlikView

I have one table ?

Mon, 20 Apr 2015 07:07:20 GMT

Hi all,

i have one table ,in table has Employee field ,

the field like this

Employee

--------------

1000-abc

1001-xyz

1002-mno

1003-def

1004-ghi

1005-klm

so i want output is like this

Employee Name

1000 abc

1001 xyz

1002 mno

1003 def

please tell me any one which functions using.

Re: I have one table ?

PrashantSangle — Mon, 20 Apr 2015 07:09:36 GMT

Hi,

Use Subfield()

subfield(FieldName,'-',1) as Employee

subfield(FieldName,'-',2) as Name

Regards

Re: I have one table ?

arulsettu — Mon, 20 Apr 2015 07:13:07 GMT

hi try this too

right(field,3) as Name,

Left(field,4) as Employee

Re: I have one table ?

raghvendrasingh — Mon, 20 Apr 2015 07:18:26 GMT

Hi,

can try this script:-

Tab1:

LOAD * INLINE [

Employee

1001-Abcfhg

1002-cDf

1003-he

1004-Yft

1005-KruFt

1006-hrtfrxcdbvdas

1007-ktg

1008-htF

1009-bejy

1010-HbJ

1011-iufewfr

];

Tab2:

Load subfield(Employee,'-',1) as Employee,

purgechar(Employee,'0123456789-') as Name Resident Tab1;

Drop Table Tab1;

Hope this will work.

Thanks,

Re: I have one table ?

Mon, 20 Apr 2015 07:26:10 GMT

thank you it's working

Re: I have one table ?

arulsettu — Mon, 20 Apr 2015 07:37:19 GMT

choose the correct answer to close this thread