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

[swuehl]

You should actually be able to do all in one load:

Load employeeno,

subfield(Skills,',') as Skills

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

[SunilChauhan]

Tab1:

Load *,

1 as Flag;

Load * inline [

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'

];

//set i=1;

for each i in Skills

Concatenate

Load employeeno,

subfield(Skills,',',$(i)) as Skills,

1 as j

resident Tab1;

next $(i)

Load *,

1 as k

resident Tab1 where Flag<>1;

drop table Tab1;

see the attched file

[alivenjess]

Hi Madhu,

It seems like you're facing an issue with executing the sub field function in your script page. It's difficult to pinpoint the exact problem without more information or seeing the snipping file you mentioned. However, I'll try my best to help you out.

To solve this problem, there are a few steps you can follow:

1. Double-check the syntax of your sub field function to ensure it's correct.
2. Verify that you're passing the correct parameters to the function.
3. Review the error message you received and try to understand what it's indicating. It might provide clues about the problem.
4. Check if you have any missing or conflicting dependencies that could be causing the error.
5. Make sure you have the necessary permissions or access rights to execute the script.

If you need bookkeeping in Croydon or have any additional questions,