how to execute subfield() function in qlikview?

[#1]

hi guys,

I create a table box with  sub field function. In script page I use a sub field () function after I reload this script but It did not execute perfectly,it shows error, i do not know how to overcome this problem. please tell me out  how to solve this problem. I attached snipping file below this box.

Regards:

madhu

[its_anandrjs]

Remove single cots from the subfield like

in place of this

SUBFIELD('SKILLS',',')AS SKILLS

Write like

SUBFIELD(SKILLS,',')AS SKILLS

Or suggest you check the position of the ',' in the SKILLS field

[#3]

Hi Madhu,

Your approach toward the problem is right but you just need some correction in your code.

They are as follows:

the field name emp in the resident load does not exist in the main table.So either change in any one of the table and make both name same.

and one morething make sure your skills column contains the data like ','.So that you will be able able to view the result.

Just make all the required changes.

Hope it will work.Thanks

Regards,

Biren Agrawalla

[#4]

thanks Srivastava it works but It gives results add old data  like this.1.table is excel data 2.is using subfield()function table. I want to results like 3 table, table name { Individual skills table.}

1.old data table:                                                                  

employeeno	Skills
159	Economics,pharmacology
163	Marketing,sociology,spanish
174	Bookkeeping,particle,Physics
210	Economics,Marketing
215	Economics,Law,Marketing
279	Law,Marketing,German
286	Finance,Marketing,French,German
300	Bookkeeping,Finance

2.after subfield()function applied display table like this:

employeeno	Skills
159	Economics
159	Economics,pharmacology
159	pharmacology
163	Marketing
163	Marketing,sociology,spanish
163	sociology
163	spanish
174	Bookkeeping
174	Bookkeeping,particle,Physics
174	particle
174	Physics
210	Economics
210	Economics,Marketing
210	Marketing
215	Economics
215	Economics,Law,Marketing
215	Law
215	Marketing
279	German
279	Law
279	Law,Marketing,German
279	Marketing
286	Finance
286	Finance,Marketing,French,German
286	French
286	German
286	Marketing
300	Bookkeeping
300	Bookkeeping,Finance
300	Finance

3.perfect table.

[#5]

thanks Agrawalla

[swuehl]

I think your second load will just concatenate to your original table.

Use a NONCONCATENATE LOAD prefix to your second table, then drop the first table at the end of your second load.

[#7]

I Wrote drop table employ skills after i reload script. it displayed empty table .when remove the drop table It reloads then it gives wrong results.

[swuehl]

emloyskills:

Load employeeno,

Skills

   
FROM
[...\Data\Employskills.xlsx]
(ooxml, embedded labels, table is Sheet1);

indskills:

NOCONCATENATE Load
employeeno, SubField(Skills,',') as Skills

Resident emloyskills;

Drop Table emloyskills;

[nizamsha]

EmployeeSkills:

Load

EmployeeNo ,

Skills 

from your Table;

MindSkills:

noconcatenate

load

EmployeeNo  as emp,

Subfield(Skills,',',-1) as Skills

resident EmployeeSkills;

[#10]

thanks tressco.

[#11]

i use noconcatenate but it gives same results.