topic Re: Need to Concatenate Data from 2 in memory table but throwing error Table not found. Please see below Script. in QlikView

Need to Concatenate Data from 2 in memory table but throwing error Table not found. Please see below Script.

Thu, 06 Feb 2014 04:50:25 GMT

Hi All,

Need to Concatenate Data from 2 in memory table but throwing error Table not found. Please see below Script. Please correct the Script if any syntax error.

I am getting ERROR:"Table not found CONCATENATE LOAD * RESIDENT DIM_ADMIN_DATA"

DIM_USER_DATA:

LOAD

'USER' END AS ACCESS,

[EMP NAME] AS USERID,

[EMP NAME] AS PASSWORD,

EMP_KEY AS _EMP_KEY

FROM DIM_EMP_DATA.QVD (qvd);

DIM_ADMIN_DATA:

LOAD * INLINE

[

ACCESS, USERID, PASSWORD, _EMP_KEY

ADMIN, ADMIN, ADMIN, *

];

Section Access; /* Start section access script */

LOAD *

RESIDENT DIM_USER_DATA;

CONCATENATE

LOAD *

RESIDENT DIM_ADMIN_DATA;

Section Application; /* End section access script */

Re: Need to Concatenate Data from 2 in memory table but throwing error Table not found. Please see below Script.

Thu, 06 Feb 2014 04:56:54 GMT

Hi,

QV implicitly concatenates the two tables as it has same columns. So it doesnot find the 2nd table.

Still if you want to do concatenate explicitly, try

DIM_USER_DATA:

LOAD

'USER' END AS ACCESS,

[EMP NAME] AS USERID,

[EMP NAME] AS PASSWORD,

EMP_KEY AS _EMP_KEY

FROM DIM_EMP_DATA.QVD (qvd);

NOCONCATENATE;

DIM_ADMIN_DATA:

LOAD * INLINE

[

ACCESS, USERID, PASSWORD, _EMP_KEY

ADMIN, ADMIN, ADMIN, *

];

HTH

-Shruti

Re: Need to Concatenate Data from 2 in memory table but throwing error Table not found. Please see below Script.

manojkulkarni — Thu, 06 Feb 2014 05:05:10 GMT

Since DIM_ADMIN_DATA & DIM_USER_DATA tables have same columns, data from DIM_ADMIN_DATA table is already concatenated with DIM_USER_DATA. So you will not find DIM_ADMIN_DATA table any more. Concatenate operation is not required at all in Section Access block.

Re: Need to Concatenate Data from 2 in memory table but throwing error Table not found. Please see below Script.

Thu, 06 Feb 2014 05:15:13 GMT

try this

if two table has same fieldname then qlikview automatically concatenate into one table.

so your Dim_Admin_Date merge in Dim_User_Date.

so when you load Dim_Adimen_Data by Resident load, then table not found error found.

for this try this

DIM_USER_DATA:

LOAD

'USER' END AS ACCESS,

[EMP NAME] AS USERID,

[EMP NAME] AS PASSWORD,

EMP_KEY AS _EMP_KEY

FROM DIM_EMP_DATA.QVD (qvd);

NoConcatenate

DIM_ADMIN_DATA:

LOAD * INLINE

[

ACCESS, USERID, PASSWORD, _EMP_KEY

ADMIN, ADMIN, ADMIN, *

];

Section Access; /* Start section access script */

LOAD *

RESIDENT DIM_USER_DATA;

CONCATENATE

LOAD *

RESIDENT DIM_ADMIN_DATA;

Section Application; /* End section access script */

Re: Need to Concatenate Data from 2 in memory table but throwing error Table not found. Please see below Script.

Thu, 06 Feb 2014 05:17:52 GMT

Thanks Vishwaranjan Kumar.

Now It is Clear for me.

Re: Need to Concatenate Data from 2 in memory table but throwing error Table not found. Please see below Script.

Thu, 06 Feb 2014 05:38:43 GMT

Hi All,

After using Above Query, When I try to lon in with any Employee name It is keep asking USERID and after 3 attempt it is denied QVW file. Could you please suggest why it is happening.

If I log in with ADMIN user and password it is working expected and with ADMIN userID i am getting "$Syn 1 = ACCESS+USERID+PASSWORD+_SP_KEY" when reloading the data. I did not understand message "$Syn 1 = ACCESS+USERID+PASSWORD+_SP_KEY"

I used this query:

DIM_USER_DATA:

LOAD

'USER' END AS ACCESS,

[EMP NAME] AS USERID,

[EMP NAME] AS PASSWORD,

EMP_KEY AS _EMP_KEY

FROM DIM_EMP_DATA.QVD (qvd);

NoConcatenate

DIM_ADMIN_DATA:

LOAD * INLINE

[

ACCESS, USERID, PASSWORD, _EMP_KEY

ADMIN, ADMIN, ADMIN, *

];

Section Access; /* Start section access script */

LOAD *

RESIDENT DIM_USER_DATA;

CONCATENATE

LOAD *

RESIDENT DIM_ADMIN_DATA;

Section Application; /* End section access script */

Re: Need to Concatenate Data from 2 in memory table but throwing error Table not found. Please see below Script.

Thu, 06 Feb 2014 05:47:54 GMT

section access use for security on application and data.

in your case when you open the application the ask

UserId and

Password

bydefault it gives 3 chaces, if you write username or password three times wrong then access is denied for open application.

so write-

Userid = ADMIN

Password = ADMIN

Re: Need to Concatenate Data from 2 in memory table but throwing error Table not found. Please see below Script.

Thu, 06 Feb 2014 05:55:36 GMT

My Question is If I enter an Employee name who is an user (as definided in below Query) and should see data belongs to him...

DIM_USER_DATA:

LOAD

'USER' END AS ACCESS,

[EMP NAME] AS USERID,

[EMP NAME] AS PASSWORD,

EMP_KEY AS _EMP_KEY

FROM DIM_EMP_DATA.QVD (qvd);

But it is not allowing to open the QVW file other than ADMIN User. why?

But Below query is working expected also for USER other than SHIVENDOO KUMAR and RAM KUMAR (These both are ADMIN as defined below.)

Section Access; /* Start section access script */

LOAD

IF(MATCH([EMP NAME],'SHIVENDOO KUMAR','RAM KUMAR'),'ADMIN','USER') AS ACCESS,

[EMP NAME] AS USERID,

[EMP NAME] AS PASSWORD,

EMP_KEY AS _EMP_KEY

FROM DIM_EMP_DATA.QVD (qvd);

Section Application; /* End section access script */

Another Problem I have seen. Both these Tables DIM_USER_DATA and DIM_ADMIN_DATA are getting appeared in Selection list. Actually I don't want to show then to end users So I tried adding SET HidePrefix = '_'; and _ before tables like _DIM_USER_DATA and _DIM_ADMIN_DATA but still these tables are getting displayed in selection list. I want to know how can I hide these tables?

Re: Need to Concatenate Data from 2 in memory table but throwing error Table not found. Please see below Script.

manojkulkarni — Thu, 06 Feb 2014 06:34:00 GMT

in your query what is 'USER'END indicates ? because Access Type will always either USER or ADMIN

DIM_USER_DATA:

LOAD

'USER' END AS ACCESS,

[EMP NAME] AS USERID,

[EMP NAME] AS PASSWORD,

EMP_KEY AS _EMP_KEY

FROM DIM_EMP_DATA.QVD (qvd);

Re: Need to Concatenate Data from 2 in memory table but throwing error Table not found. Please see below Script.

Thu, 06 Feb 2014 06:39:38 GMT

Hi Manoj,

Sorry. That is copy past mistake. I checked code and code is like below:

DIM_USER_DATA:

LOAD

'USER' AS ACCESS,

[EMP NAME] AS USERID,

[EMP NAME] AS PASSWORD,

EMP_KEY AS _EMP_KEY

FROM DIM_EMP_DATA.QVD (qvd);

Re: Need to Concatenate Data from 2 in memory table but throwing error Table not found. Please see below Script.

Thu, 06 Feb 2014 07:10:09 GMT

Hi All,

This does not work (It is not allowing other that ADMIN USER to access QVW)

DIM_USER_DATA:

LOAD

'USER' AS ACCESS,

[EMP NAME] AS USERID,

[EMP NAME] AS PASSWORD,

EMP_KEY AS _EMP_KEY

FROM DIM_EMP_DATA.QVD (qvd);

NOCONCATENATE

DIM_ADMIN_DATA:

LOAD * INLINE

[

ACCESS, USERID, PASSWORD, _EMP_KEY

ADMIN, ADMIN, ADMIN, *

];

Section Access; /* Start section access script */

LOAD *

RESIDENT DIM_USER_DATA;

CONCATENATE

LOAD *

RESIDENT DIM_ADMIN_DATA;

Section Application; /* End section access script */

This does not work: (Not Allowing any User to access QVW even for ADMIN it is failing)

Section Access; /* Start section access script */

DIM_USER_DATA:

LOAD

'USER' AS ACCESS,

[EMP NAME] AS USERID,

[EMP NAME] AS PASSWORD,

EMP_KEY AS _EMP_KEY

FROM DIM_EMP_DATA.QVD (qvd);

NOCONCATENATE

DIM_ADMIN_DATA:

LOAD * INLINE

[

ACCESS, USERID, PASSWORD, _EMP_KEY

ADMIN, ADMIN, ADMIN, *

];

LOAD *

RESIDENT DIM_USER_DATA;

CONCATENATE

LOAD *

RESIDENT DIM_ADMIN_DATA;

Section Application; /* End section access script */

But this is working as expected and It is also not showing DIM_USER_DATA to user (In Selection list) as it is under Section Access;

Section Access; /* Start section access script */

DIM_USER_DATA:

LOAD

'USER' AS ACCESS,

[EMP NAME] AS USERID,

[EMP NAME] AS PASSWORD,

EMP_KEY AS _EMP_KEY

FROM DIM_EMP_DATA.QVD (qvd);

//NOCONCATENATE

DIM_ADMIN_DATA:

LOAD * INLINE

[

ACCESS, USERID, PASSWORD, _EMP_KEY

ADMIN, ADMIN, ADMIN, *

];

LOAD *

RESIDENT DIM_USER_DATA;

//CONCATENATE

//LOAD *

//RESIDENT DIM_ADMIN_DATA;

Section Application; /* End section access script */

Re: Need to Concatenate Data from 2 in memory table but throwing error Table not found. Please see below Script.

manojkulkarni — Thu, 06 Feb 2014 07:19:04 GMT

Pls try below code, it is working for both access type.

LOAD * INLINE [

ACCESS, USERID, PASSWORD, _EMP_KEY

USER, MANOJ, MANOJ, 12

USER, EMP1, EMP1, 13

];

DIM_ADMIN_DATA:

LOAD * INLINE

[

ACCESS, USERID, PASSWORD, _EMP_KEY

ADMIN, ADMIN, ADMIN, *

];

STAR is *;

Section Access; /* Start section access script */

LOAD *

RESIDENT DIM_USER_DATA;

Section Application; /* End section access script */

Re: Need to Concatenate Data from 2 in memory table but throwing error Table not found. Please see below Script.

manojkulkarni — Thu, 06 Feb 2014 07:21:34 GMT

Hide prefix will work only for fields. Below content from Qlikview help file.

HidePrefix

All field names beginning with this text string will be hidden in the same manner as the system fields. A user-defined variable.

Example:

set HidePrefix='_' ;

If this statement is used, the field names beginning with an underscore will not be shown in the field name lists when the system fields are hidden