Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

andrewmcgough
New Contributor II

Is there a limit to the number of fields that can be used in Section Access

Hi.

We have 9 fields as part of data reduction (Section Access). If I add a 10th field, the script fails (general script failure with no additional information provided in the logs)

I cant seem to find anything in the community that confirms this is a known limitation.

Thanks

10 Replies
Digvijay_Singh
Honored Contributor III

Re: Is there a limit to the number of fields that can be used in Section Access

No such restriction mentioned in reference manual though, just attaching hic‌ blog in case it can help.

Data Reduction Using Multiple Fields

MVP
MVP

Re: Is there a limit to the number of fields that can be used in Section Access

Could you post your sample script?

andrewmcgough
New Contributor II

Re: Is there a limit to the number of fields that can be used in Section Access

If you run the below it works without any error.

But, if more than 9 fields are listed the code fails, ie if you uncomment "FLAG_J". It doesn't matter which fields are included or excluded, but if there are more than 9 it fails. The logs don't give any reason for the failure.

Section Access;

Star is *;

AuthorisationTable:

LOAD Upper(Trim(ACCESS)) as ACCESS,
Subfield('domainA,domainB,domainC,',',')& '\' & Upper(NTNAME) as NTNAME,
Upper(NTNAME) as MAPPER,
FLAG_A,
FLAG_B,
FLAG_C,
FLAG_D,
FLAG_E,
FLAG_F,
FLAG_G,
FLAG_H,
FLAG_I
// FLAG_J
FROM
[Security Test.xlsx]
(ooxml, embedded labels, table is Reduction);


//----------Add Service Accounts to Section Access
Concatenate (AuthorisationTable)
LOAD * inline [ACCESS,NTNAME
ADMIN,domainA\zzzzzz
ADMIN,domainB\xxxxxxx
ADMIN,domainC\yyyyyyyy
]
;

//**********************************************************************************
Exit Script;
//**********************************************************************************

MVP
MVP

Re: Is there a limit to the number of fields that can be used in Section Access

I can't replicate the issue. I tried with 11 fields and it worked fine with me. Could you post your qvw with sample data that demonstrates the issue?

MVP
MVP

Re: Is there a limit to the number of fields that can be used in Section Access

Is the issue also present when you remove the line

Star is *;

?

Gabriel
Valued Contributor II

Re: Is there a limit to the number of fields that can be used in Section Access

Hi,

Have you try debugging each section of the script?

Comment out Star is *;

Comment out the last script this section

/----------Add Service Accounts to Section Access
Concatenate (AuthorisationTable)
LOAD * inline [ACCESS,NTNAME
ADMIN,domainA\zzzzzz
ADMIN,domainB\xxxxxxx
ADMIN,domainC\yyyyyyyy
]
;


It's possible that the issue is not the number of fields loaded



andrewmcgough
New Contributor II

Re: Is there a limit to the number of fields that can be used in Section Access

Hi, If I remove the last section of code “Concatenate (AuthorisationTable)” the code works, but this still doesn’t explain why the original code fails

andrewmcgough
New Contributor II

Re: Is there a limit to the number of fields that can be used in Section Access

If "Star is *"  is removed the error still occurs.

Gabriel
Valued Contributor II

Re: Is there a limit to the number of fields that can be used in Section Access

Hi,

Try and save this section into QVD and then bring it back in and concatenate it to AuthorisationTable'

/----------Add Service Accounts to Section Access
Concatenate (AuthorisationTable)
LOAD * inline [ACCESS,NTNAME
ADMIN,domainA\zzzzzz
ADMIN,domainB\xxxxxxx
ADMIN,domainC\yyyyyyyy
]
;

Community Browser