topic Re: Section Table by Resident load in QlikView

Section Table by Resident load

Fri, 17 Jan 2014 14:28:51 GMT

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 ?

Re: Section Table by Resident load

hic — Fri, 17 Jan 2014 14:37:48 GMT

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

HIC

Re: Section Table by Resident load

Fri, 17 Jan 2014 14:43:11 GMT

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.

Re: Section Table by Resident load

hic — Fri, 17 Jan 2014 15:02:49 GMT

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

HIC

Re: Section Table by Resident load

Fri, 17 Jan 2014 15:05:13 GMT

Hi Henric , Typo mistake here.

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

Re: Section Table by Resident load

Anonymous — Fri, 17 Jan 2014 15:08:12 GMT

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.

Re: Section Table by Resident load

Fri, 17 Jan 2014 15:11:25 GMT

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

Re: Section Table by Resident load

Anonymous — Fri, 17 Jan 2014 15:12:21 GMT

See my "edit"...

Re: Section Table by Resident load

Fri, 17 Jan 2014 15:17:14 GMT

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

Re: Section Table by Resident load

hic — Fri, 17 Jan 2014 15:22:40 GMT

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

Re: Section Table by Resident load

Fri, 17 Jan 2014 15:36:15 GMT

Henric, I have one question on this.

The Section table is also auto concatenated to previously loaded table if the section table have same fields like previously loaded table?

Why I am asking this question is , the Mapping table can't be auto concatenated to previously loaded table even though the mapping table have the same field names like previously loaded table.

Moreover, Mapping tables & Section table does n't exist on the data model.

(Mapping table was dropped at the end of execution)

Re: Section Table by Resident load

msteedle — Mon, 05 May 2014 15:10:44 GMT

I can't really verify how this is working behind the scenes but it seems like loading from anything other than a resident table automatically converts to uppercase between Section Access and Section Application. Doing a resident load of mixed case data there may lock you out.

Just doing this would probably resolve your problem:

SectionTable:

LOAD Upper(NTNAME) as NTNAME,

Upper(A) AS ACCESS ,

Upper(B) AS DEPARTMENT

Resident TempSecurity ;

...although you can do table concatenation between Section Access and Section Application, so you may just be able to skip the resident problem entirely.

Re: Re: Section Table by Resident load

IAMDV — Mon, 05 May 2014 19:43:37 GMT

I've used Resident Load in Section Access script and it works great. I guess it's combination of QVD Load and Resident Load in Section Access causing the problem. I remember having this issue in the past. Have you tried to bring the data from the Excel file instead of QVD? Just to test if it's Resident Load or QVD Load.

Cheers,