topic Re: Script extract in QlikView

Script extract

hkg_qlik — Tue, 12 Jun 2012 19:04:59 GMT

Hi,

I have a field called department which holds multiple information. I need to extract Organization. info from the department data populated for each row.

Example:

Dep.ID Department

1 ABC - Helpdesk

2 XYZ - HR

3 NULL

4 IT

5 ABC - Network

Now I want to create an Organization field during my loading process to extract only ABC, XYZ values. If its null or does not contain a - I don't want to extract info for that row.

Regards,

Re: Script extract

Tue, 12 Jun 2012 19:30:38 GMT

temp: LOAD * INLINE [

DepID, Department

1, ABC - Helpdesk

2, XYZ - HR

3, NULL

4, IT

5, ABC - Network

];

Final:

noconcatenate

Load DepID,

If(Index(Department,'-')>0,Left(Department,Index(Department,'-')-1),'') AS Department_Final

RESIDENT temp;

Drop Table temp;

Re: Script extract

sivarajs — Wed, 13 Jun 2012 05:21:35 GMT

Just to simplify use subfield(Department,'-',1) as field while loading your script