Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Section Table by Resident load

Hi All, I am facing very wired problem as my section access is not Working when I am creating the Section Table with Resident Load

Then I changed to QVD its working fine.

Here is my script (Resident Load):

TempSecurity:

LOAD NTNAME ,

          ACCESS ,

          DEPARTMENT

FROM BI_SALES_SECURITY.qvd (qvd) ;

//Adding some new departments to existing qvd

Concatenate (TempSecurity)

LOAD * INLINE [

NTNAME , ACCESS , DEPARTMENT

**** ,***** ,******

****,*****,*****

****,*****,*******

];

Section Access:

SectionTable:

LOAD NTNAME ,   

          ACCESS ,

          DEPARTMENT

Resident TempSecurity ;

Section Application ;

The above script is not worked for me. The script executed with out any error and I tried and to open after reload I git Access denied Error.

So I create another qvw where I add the INLINE table and creates the new security qvd and Section Access worked.

Why Resident Load is not worked on SectionTable ?

12 Replies
Employee
Employee

Re: Section Table by Resident load

Probably because the autoconcatenate kicks in. Try using Noconcatenate on the last Load.

HIC

Not applicable

Re: Section Table by Resident load

I tried with breaking the Auto concatenation by changing the filed name in the TempSecurity table Like below:

TempSecurity:

LOAD NTNAME ,

          ACCESS AS A,

          DEPARTMENT AS B

FROM BI_SALES_SECURITY.qvd (qvd) ;

//Adding some new departments to existing qvd

Concatenate (TempSecurity)

LOAD * INLINE [

NTNAME , A , B

**** ,***** ,******

****,*****,*****

****,*****,*******

];

Section Access:

SectionTable:

LOAD NTNAME ,  

          A AS ACCESS ,

          B AS DEPARTMENT

Resident TempSecurity ;

Section Application ;

This is one also still not working.

Employee
Employee

Re: Section Table by Resident load

You have a colon ":" after "Section Access". You should have a semicolon ";"

HIC

Not applicable

Re: Section Table by Resident load

Hi Henric , Typo mistake here.

currently I am using 11.2 SR2 version. Is there any reason why resident load is not working ?

mov
Esteemed Contributor III

Re: Section Table by Resident load

Try using upper() function:

upper(NTNAME) as NTNAME

upper(ACCESS) as ACCESS

...

Edit: Section Access must use uppercase values.  I recommend to always use this function in Section Access except the inline load.  Even if you know that fields are already in uppercase in the database or excel or etc.


Not applicable

Re: Section Table by Resident load

The data already in Upper case , we are converting to UPPER Case already in QVD.

mov
Esteemed Contributor III

Re: Section Table by Resident load

See my "edit"...

Not applicable

Re: Section Table by Resident load

Ok. I will try that and I will let you know.....

Employee
Employee

Re: Section Table by Resident load

I agree with Michael on the Upper() function. And - no - I do not see why it shouldn't work.

Commenting the "Section Access;" statement is one good way to debug...

HIC

Community Browser